A trial balance sheet captures the activity across different accounts of a company with regard to the opening and closing balances. The following recipe focuses on the creation of a trial balance sheet in Qlik Sense.
The recipe will make use of the Trial Balance.xlsx
file, which can be downloaded from the Packt Publishing website. Store the file on your system at the following location: C:/QlikSense
.
- Create a folder connection to the
Trial Balance.xlsx
file. Name itQlikSenseCookBook _TB
. - Load the data from the
TrialBalance.xlsx
file in the Qlik Sense file. We need to make use of the cross-table functionality to load the data in a proper format:
Let vMaxMonth=Max(Month); TrialBalancetemp: CrossTable(Month, Amount, 4) LOAD [Company Number], [Account Number], [Year], Forwarded, [January], [February], [March], [April], [May], [June], [July], [August], [September], [October...