Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I ended up doing the aggregation in the script, and that really improved the performance. Thanks for the follow up.
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
I ended up doing the aggregation in the script, and that really improved the performance. Thanks for the follow up.