topic Re: Displaying line charts only for selected dimensions in QlikView

Displaying line charts only for selected dimensions

zakpullen — Sat, 16 Nov 2024 02:00:37 GMT

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?

Many thanks.

Re: Displaying line charts only for selected dimensions

DeeptiRao — Thu, 07 Nov 2019 14:06:47 GMT

Hi,

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

Re: Displaying line charts only for selected dimensions

zakpullen — Thu, 07 Nov 2019 14:38:19 GMT

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.

Re: Displaying line charts only for selected dimensions

DeeptiRao — Wed, 13 Nov 2019 10:17:42 GMT

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.

Re: Displaying line charts only for selected dimensions

zakpullen — Wed, 13 Nov 2019 11:46:21 GMT

Perfect, thank you so much!