Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
md_qlikview
Creator II
Creator II

Set Analysis Help

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like:

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

View solution in original post

2 Replies
tresesco
MVP
MVP

May be like:

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

md_qlikview
Creator II
Creator II
Author

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

Thanks much