Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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?
Best Regards,
Louis
Hi Louis,
try to put a space between Crosstable and the parenthesis like this:
before:
Crosstable(MonthNum,value,1)
after:
Crosstable (MonthNum,value,1)
it should work
Hi Michele,
Thanks for reply.
I tried but no luck.
Best Regards,
Louis
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:
TEST_TEMP:
CrossTable(Date, Data, 2)
LOAD *
FROM [Assignment.xlsx](biff, embedded labels, table is Assignment)
where Date <> 'Total';
NOCONCATENATE
TEST:
LOAD *
Resident TEST_TEMP where Date <> 'Total';
Drop Table TEST_TEMP;