topic Re: Reduce memory usage from expression in QlikView

Reduce memory usage from expression

Anonymous — Tue, 05 Jun 2018 15:45:00 GMT

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.

Re: Reduce memory usage from expression

sunny_talwar — Tue, 05 Jun 2018 16:48:32 GMT

The best way would be to use

The As-Of Table

Re: Reduce memory usage from expression

marcus_sommer — Wed, 06 Jun 2018 08:59:37 GMT

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