topic Another set analysis question in QlikView

Another set analysis question

Thu, 25 Feb 2010 11:48:38 GMT

I have a heavy application where I often get out of memory errors. I get it every time I deselect selections on the page where I have a table containing the below expression:

sum(aggr(if(Aktions_Koder2='1_brev_slutdato2' and

MATRIX_DATE>Max((date(Aktions_Startdatoer2))) and

MATRIX_DATE<max((date(Aktions_Slutdatoer2 )))

and BetaltNøgle<>0

and

(FUNCTION_CODE='BE' or FUNCTION_CODE='DB' or FUNCTION_CODE='OB'),AMOUNT),TRANS_NO,CASE_ID,Aktions_Startdatoer2,Aktions_Slutdatoer2,Aktions_Koder2))

I will therefore try to see if it uses less memory with set analysis but no matter what I write it returns 0 so I'm obliviously doing something wrong.

Can anyone turn the above aggr into set analysis ?

Another set analysis question

Thu, 25 Feb 2010 13:17:31 GMT

For complex expressions like this, you should consider resolve in script, creating a field for this case. You will have a better performance too.

Another set analysis question

Thu, 25 Feb 2010 13:26:21 GMT

Thanks for the input. I will see if that is duable but I'm not that confident as the fields are from 4 different tables and the virtual memory on my machine is already at its max - fails often when reloading the application.