Memory issue with one particular straight table ?

swarup_malli — Mon, 30 Jan 2012 21:48:43 GMT

Hi,

I have a Straight table , it has 30 columns, about 3 dimensions and 27 columns as expressions .I'm using dimensions as expressions as its supposed to reduce memory.

But the problem is whenever the tab containing this particulat table is selected , this particular table takes lot of memory. Takes forever to load.

The table contains more than 200 thousand rows.

Is there a way i can overcome this issue.

Thanks

Memory issue with one particular straight table ?

ivandrago — Mon, 30 Jan 2012 23:31:26 GMT

Might be best to add a calculation condition to limit the row set:

On General Tab of Chart add a expression under the Calculation Condition:

Count(Distinct [PK])<30000

replace PK with your unique field, the above will only show rows of upto 30,000

topic Memory issue with one particular straight table ? in QlikView

Memory issue with one particular straight table ?

Memory issue with one particular straight table ?