Aggr Function expression issue

Fri, 28 Jun 2013 09:52:51 GMT

Hi All,

I am facing some performance issues in a qlikview application that process around 50 Mil rows of data.

The issue is 2 fold:

> We have multiple drill groups in the applications and are displaying labels at multiple places based on the current drill down group level. Hence a lot of nested ifs are there.I am just thinking if nested ifs can be converted to something more efficient.

> We are using aggr functions in many expressions that could be causing slowness. An example format of the aggr logic we are using is this. I am thinking if it can be replaced with a set expression, but not sure. What set expression would it be.

=sum(if(aggr(sum({<[Unique ID]={">0"}>}' & Chr(36) & '(GrossSales)),' & Chr(36) & '(vAggrHierarchyFieldName), [uniqueIDs])>=10000,1,0))

Here vAggrHierachyFieldName is a nested iff to get the field name of the current level of the drill down group. Its again a nested iff statement.

Please suggest.

Thanks

Raghu

Re: Aggr Function expression issue

Fri, 28 Jun 2013 10:35:36 GMT

Hi,

just an idea.

Maybe the function getcurrentfield(GroupName) can solve your issue. It displays the Name of the actike Field in the drill down group

Re: Aggr Function expression issue

Fri, 28 Jun 2013 11:56:39 GMT

Is there any way to convert the Aggr based expression into set analysis. I have a feeling that its too heavy.

Thanks

Raghu

topic Re: Aggr Function expression issue in QlikView

Aggr Function expression issue

Re: Aggr Function expression issue

Re: Aggr Function expression issue