I have a 3 dimensional excel sheet and need to load it in Qlick View (Account, Amount, Date) ....
I have attached a sample of the excel sheet .... any help
split the excel into two excel files
one is for Debit and another is for Credit.
do the crosstable function,
Load separately then join both the tables.
Retrieving data ...