Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Partner
Partner

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
Partner
Partner

Re: Alternate State Selections

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

Re: Alternate State Selections

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

Re: Alternate State Selections

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

Partner
Partner

Re: Alternate State Selections

Great! you welcome.
Arvinffernandez
New Contributor

Re: Alternate State Selections