topic Re: Set Analysis Help in Archived Groups

Set Analysis Help

md_qlikview — Tue, 22 Jul 2025 17:59:49 GMT

Hello Everyone,

I am having a scenario where i have written an expression

sum(Aggr(Sum({<Producttype=>} Sales),Region))

Since producttype has nothing to do with my calculation, but due to some other requirement i

have to use it on the front end. Hence i have nullified it in this expression.

Now my question is when i select Producttype on the front end, Region field becomes grey i.e. zero or

no value, since there is no linking between them and ultimately my calculation for sales for above expression also gives

me zero which is wrong. So is there any way so that i can accomplish this using set analysis.

Thanks In Advance

Re: Set Analysis Help

Gysbert_Wassenaar — Fri, 22 May 2015 05:27:26 GMT

Try sum({<Producttype=>} Aggr(Sum({<Producttype=>} Sales),Region)).

If that doesn't do what you want please post a qlikview document that demonstrates the problem.

Re: Set Analysis Help

jonathandienst — Fri, 22 May 2015 05:59:03 GMT

I think the problem is that because the selection results in no values for Region, there is nothing for the aggr() dimension to iterate over. But why do you need the aggregate? =Sum({<Producttype=>} Sales) should suffice.

Re: Set Analysis Help

md_qlikview — Sun, 31 May 2015 12:55:23 GMT

thanks for you reply....i could not get back to my post. But it worked the same way that you have mentioned

thanks much

Re: Set Analysis Help

cotiso_hanganu — Fri, 14 Aug 2015 19:29:03 GMT

you should mark the issue as answered !