topic buckets with aggr function - inefficient? in QlikView

buckets with aggr function - inefficient?

exfosteve — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to build a table with multiple aggregation levels.

Frequency = count(if(aggr(count(if([Lost Data]>0,1)),Node,Date,[Time 5min])>0,1))

=aggr(if($(getDefinition(Frequency)) = 0, dual('No Loss',0),

if($(getDefinition(Frequency)) <= freq01, dual('inFrequent',1),
if($(getDefinition(Frequency)) <= Freq02, dual('Fairly Frequent',2),
if($(getDefinition(Frequency)) <= Freq03, dual('Very Frequent',3),
if($(getDefinition(Frequency)) > Freq03, dual('Watchout',4)))))), [Node])

I have 3 variables that the user defines (freq01, freq02, freq03).

I just seems like this is very inefficient. Is there a better way to to do this?

Re: buckets with aggr function - inefficient?

Brett_Bleess — Thu, 22 Aug 2019 20:49:49 GMT

Steve, check the following site, use the search box to see if you can find any posts there that will give you further ideas. I would recommend starting with a single word on the search, see what pops up and use the words there to refine further. There are hundreds of posts in this area, so hopefully you can find one that will be of use to you. I was not really sure, and rather than screw you up, figured it would be better to just let you have a look yourself in this case, good luck, hopefully something there will help.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: buckets with aggr function - inefficient?

exfosteve — Mon, 26 Aug 2019 15:35:39 GMT

I ended up doing the aggregation in the script, and that really improved the performance. Thanks for the follow up.