Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zakpullen
Contributor III
Contributor III

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
Contributor III
Contributor III
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.

View solution in original post

zakpullen
Contributor III
Contributor III
Author

Perfect, thank you so much!