Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
diwakarnahata
Creator
Creator

Set Analysis to filter on a single column only

Hi,

I need to write an expression which gives me Sum(Sales) and this should change only if I select Region, else it should remain the same.

For. e.g. if there are 3 regions with sales of 100 units each, then initially without anything selected the expression should show 300, if a region is selected then it shows 100. After this, even if any more different filters are applied, it should show 100 only.

How could this be achieved?

Regards,

Diwakar

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This might help you

http://community.qlik.com/message/253623#253623

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
stigchel
Partner - Master
Partner - Master

Not entirely sure what you are after, but I think the direction you are looking for implies setting a variable on the selection of region. You then use the contents of that variable in a set expression. The variable only changes when you make a selection on region, so other selections are disregarded.

Depending on what you want the expression could be something like:

Sum({1<Region={'$(vRegion)'} Sales)

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This might help you

http://community.qlik.com/message/253623#253623

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein