Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Specialist
Partner - Specialist

Alternate State Selections

Hi

I am using Alternate States in Qlik Sense via Filter Panes and I need to show the selections that the use has made in each of the filter panes as part of the heading of a chart.

In the example below, you can see 2 sets of filter panes ones for each Alternate State ("Set 1"  and "Set 2").  In this example take the "Year" for example its a dimension called "DispatchDate" for both sets, the top is Set 1 and the bottom Set 2. Once I have made my selections (for example 2018 for Set 1 and 2017 for Set 2) the user cannot see what the bars in the chart below represent - it would be great to include the selections of each set as part of a heading or in a text box alongside the chart, e.g. "Comparative Analysis by Station (2018 vs. 2017) in this example - does anyone know how I can extract the selections made in each set?


Comparative Analysis.jpg

 

Labels (2)
1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

you can use GetCurrentSelection function as below:
=GetCurrentSelections(',',',',',','10','Set 1')
i hope it can help.

View solution in original post

4 Replies
agigliotti
Partner - Champion
Partner - Champion

you can use GetCurrentSelection function as below:
=GetCurrentSelections(',',',',',','10','Set 1')
i hope it can help.
alexis
Partner - Specialist
Partner - Specialist
Author

Dear Agigliotti

EXCELLENT response. Based on your reply I fine-tuned the code a little to:

= GetCurrentSelections('>'&chr(10),': <',',','10','Set 1')

to produce this which is EXACTLY what I wanted - THANKS!

Comparative AnalysisSelections2.jpg

agigliotti
Partner - Champion
Partner - Champion

Great! you welcome.
Arvinffernandez
Contributor
Contributor