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

Is there a size limitation of Qlik sense resident table?

I would like to do a calculation from two different tables during data load editor, so I used the resident table.

It works when I tested with some small size dummy data. However, when using the same logic to do the calculation from two resident tables with more than 100MB, there would be error.

The error says the resident table is not found.

Any suggestion is appreciated!

1 Solution

Accepted Solutions
vinieme12
Not applicable

Re: Is there a size limitation of Qlik sense resident table?

There is no limit

The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table

Write keyword NOCONCATENATE

before the load statement of your resident table.

2 Replies
vinieme12
Not applicable

Re: Is there a size limitation of Qlik sense resident table?

There is no limit

The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table

Write keyword NOCONCATENATE

before the load statement of your resident table.

datalakeyu
Not applicable

Re: Is there a size limitation of Qlik sense resident table?

Hey Vineeth, thanks so much for your help!

I nearly forget the CONCATENATE issue between two tables. This is very possible the reason. Let me check.

Thanks again!