Quick question about aggr function

Fri, 18 Dec 2009 14:56:51 GMT

I've got problem with memory in my aplication. I'm wondering how much the aggr function (is used about 5-10 times in tables) is allocating so much memory.

This is example of using aggr function


sum(aggr(nodistinct (sum(SAP_PLN)/sum(SAP_ilosc)*if(Match(Left(BW_AUFTR_STKL.BOM_PRODUKT,1),'1','2','4')>0,sum(BW_AUFTR_STKL.STL_QM/(1-GLA)),sum(BW_AUFTR_STKL.STL_LFM))),BW_AUFTR_POS.PROD_ID,ID_POZYCJI,BW_AUFTR_STKL.BOM_PRODUKT)*BW_AUFTR_POS.PP_MENGE)

Quick question about aggr function

johnw — Sat, 19 Dec 2009 05:35:39 GMT

I think of the aggr() function as creating a little temporary table of its own. So it's like you've created a new table with three dimensions and a fairly complicated expression. And you do this for every row in your original table. If QlikView processes these temporary tables one at a time in sequence, then it would just use as much memory as if you built the table yourself and selected the values for that specific row in your original table. But for all I know, QlikView may try to create a lot of these temporary tables in parallel, which could eat up a lot more memory. I don't really know how it's behaving internally.

topic Quick question about aggr function in QlikView

Quick question about aggr function

Quick question about aggr function