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.

ThanksIn Advance

Re: Set Analysis Help

tresB — Fri, 22 May 2015 04:33:21 GMT

May be like:

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

md_qlikview — Fri, 22 May 2015 04:55:56 GMT

Absolutely, bull's eye. its working accurately. Thanks a lot tresesco.

Thanks much