Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to select whole set, using variables in set analysis.

Hi

I have been trying to figure out how to select a set of everything. I have a graph where I want the data of each expression to be chosen by the user throough selction boxes.

At the moment the user can choose to see avg(sales) or median(sales)

I want them to be able to select specific sets for each line on the graph.

So they can choose which contry and what product the average sales line shows while the median line shows a different product and contry that they selected,

the expression I use is

 

avg

({1< Country ={'$(vLine1Country)'},Product ={'$(vLine1Product)'}>}Sales),

vLine1Country is a variable set by the user using a selection box with predetermined fields.

The problem with this expression is the user can not deselect a country and see a set of all the countries, or choose more than one country which is what I need.

If anyone can suggest a method of doing this I would be very greatful.

I'm using qlikview v10

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try using '*', which would work if typed into a list box search field.

Jonathan

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Try using '*', which would work if typed into a list box search field.

Jonathan

Not applicable
Author

Thankyou so much!! Can't believe I never thought of doing that!!