Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Reduce memory usage from expression

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.



2 Replies
sunny_talwar

The best way would be to use

The As-Of Table

marcus_sommer
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