Reduce memory usage from expression

[Anonymous]

HI!

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.

[sunny_talwar]

The best way would be to use

The As-Of Table

[marcus_sommer]

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