Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 - Creator
Partner - Creator

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!