How to add the value from filter pane to the title... - Qlik Community

Anonymous · ‎2018-10-29

Hi,

I have 2 line charts on a single sheet and I have to add titles for the charts. For it, I am required to add the filter pane value that corresponds to the chart. Let's say, I have a filter value for country A and country B. I want to display the title of my 1st chart to display A and the 2nd chart as B. How to carry on this functionality in Qlik Sense?

Thanks in advance!

-Nishtha

vishsaggi · ‎2018-10-29

Try this in your chart title like

Chart1

= Subfield(GetFieldSelections(Country), ',',1)

Chart2

= Subfield(GetFieldSelections(Country), ',',2)

Anonymous · ‎2018-10-30

Thanks Vishwarath for your response.

I tried your solution but for Chart 1 it is showing me 'ALL' instead of the 1st ticked value colored in green which I actually want to display and for Chart 2 , it is just showing '-'(dash) when I put the expression. Can you please let me know as to why this is happening and is there any other solution to carry out this?

-Nishtha

vishsaggi · ‎2018-10-30

can you share the screenshots and also the expression your are using? And where you are using these expressions?

How to add the value from filter pane to the title of the sheet?