Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
tiklam_dynasys
Not applicable

Crosstable lead to keep loading

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

5 Replies
micheledenardi
Not applicable

Re: Crosstable lead to keep loading

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

tiklam_dynasys
Not applicable

Re: Crosstable lead to keep loading

Hi Michele,

Thanks for reply.

I tried but no luck.

Best Regards,

Louis

balabhaskarqlik
Not applicable

Re: Crosstable lead to keep loading

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

tiklam_dynasys
Not applicable

Re: Crosstable lead to keep loading

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
Not applicable

Re: Crosstable lead to keep loading

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;