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: 
AK9934
Contributor II
Contributor II

Need to filter a chart by dimension values

Hi, I am using donut chart having division name as dimension and count({<status={'a','b','c'}>}id) 

Now if select 'a' value in status filter the chart should change accordingly and if none selected from the filter it should take all 3 values from status.

 

Can anyone please help, how to achieve this in qliksense.

3 Replies
SterreKapteijns
Partner Ambassador
Partner Ambassador

So you mean when selecting the value 'a' in the field, only 'a' is shown in the donut, otherwise 'a'/'b'/'c'.

I believe, you can use the dollar sign expansion:

count({$<status={'a','b','c'}>}id) 

Set analysis and set expressions | QlikView Help

SunilChauhan
Champion II
Champion II

Use $ which generally used for selection in set Analysis.  below expression has a,b,c . Should work on Selection of a or b orc

count({$<status={'a','b','c'}>}id).

Hope this help

Sunil Chauhan
MatheusC
Specialist II
Specialist II

Using the * wildcard character when specifying your filter in set analysis will allow you to change the value according to the user's selection, in addition to showing all listed values:

<status*={'a','b','c'}>

- Regards, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!