Discussion Board for collaboration related to QlikView App Development.
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
The As-Of Table
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.