Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Reduce memory usage from expression


Thanks to Sunny and Gysbert  I have this beautiful expression now ...

=Concat(Aggr(If( ProductQteRetourAvecPack >= RangeSum(Above(Sum(O_PO_FinalQty) , 1, RowNo()) ), O_PO_PurchaseId), ProductCode, O_PO_ROW), ', ', O_PO_ROW )

It works great ... but when I go on the sheet that has the chart with it, I go from 3 Gig memory to 8 Gig memory ...  (for about 7000 lines)

Is there a way to reduce this , like put it in a variable maybe, or find a way to put this in the load script ...

Any suggestion to optimize would be appreciated.

2 Replies

The best way would be to use

The As-Of Table

MVP & Luminary
MVP & Luminary

Some (more or less expensive) changes within the datamodel might reduce the size of the temporary table which Qlik creates to calculate this expression. See here what is meant: Logical Inference and Aggregations.

- Marcus