Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
zakpullen
Creator
Creator

Displaying line charts only for selected dimensions

Hi,

The chart below shows how the age of employees is distributed (as a % of the selected group). Rather than have a messy chart showing showing the line for all groups, I would like to allow users to select the groups they would like to compare, and show those only.

I've tried creating seperate expressions for each group (e.g. Count(DISTINCT {<[Group]={Group 1'}>}[Employee Number])), with corresponding conditional shows (e.g. Group='Group 1'), but this only works for single selections.

This seems like it would be a useful function in general. How could it be done?

Capture.JPG

Many thanks.

Labels (3)
1 Solution

Accepted Solutions
DeeptiRao
Contributor II
Contributor II

Try using below expression in 'conditional' expression option

WildMatch(GetCurrentSelections(),'*MatchingValue*') .

I have attached a sample solution with sample data.

Hope this works for you.

View solution in original post

4 Replies
DeeptiRao
Contributor II
Contributor II

Hi,

In expression,  check the 'conditional' option and give appropriate condition to show and hide expression as per user selection.

zakpullen
Creator
Creator
Author

That doesn't work. With the straightforward condition I quoted, the chart only works if one is selected. If a conditional select is the answer, it would need to work for multiple selections.

DeeptiRao
Contributor II
Contributor II

Try using below expression in 'conditional' expression option

WildMatch(GetCurrentSelections(),'*MatchingValue*') .

I have attached a sample solution with sample data.

Hope this works for you.

zakpullen
Creator
Creator
Author

Perfect, thank you so much!