Crosstable lead to keep loading

[Anonymous]

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

[micheledenardi]

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

[Anonymous]

Hi Michele,

Thanks for reply.

I tried but no luck.

Best Regards,

Louis

[balabhaskarqlik]

Crosstable() should work with / without space, but after crosstable is there any Resident load processed, Drop table is applied or not?

[Anonymous]

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.

[balabhaskarqlik]

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;