I have created an app in desktop version which work fine.
However, when i copy the code the Qlik Sense server and it keeps loading after pressing the button "Load Data"
When i comment the code "Crosstable(MonthNum,value,1)"
it will work fine.
Anyone know the reason?
try to put a space between Crosstable and the parenthesis like this:
it should work
Thanks for reply.
I tried but no luck.
Crosstable() should work with / without space, but after crosstable is there any Resident load processed, Drop table is applied or not?
When i put first 200,000 after the crosstable, it will work.
However, there is only around 30,000 rows of record are required to load after using crosstable.
Can you try like this:
CrossTable(Date, Data, 2)
FROM [Assignment.xlsx](biff, embedded labels, table is Assignment)
where Date <> 'Total';
Resident TEST_TEMP where Date <> 'Total';
Drop Table TEST_TEMP;
Retrieving data ...