Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The best way would be to use
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