Dynamic Chart Title Based on Alternative Dimension Selection

[drunk8gods]

Hello all,

I'm working on a dashboard and am fairly new with Qlik Sense.  Hoping I can get some assistance.

I have a pie chart set up with various alternative dimensions.  This allows the user to select what dimension they would like displayed on the pie chart.

What I was hoping to do was display a title such as "Volume by " (Dimension), with the Dimension being the name of the dimension that is selected in the chart.

I'm not looking for a particular value within the selected dimension, just the name of the dimension (or alternative dimension) that is selected so it can be displayed on the title.

Thanks.

[Gysbert_Wassenaar]

Afaik there's no way to find out which alternative dimension is active.

[MK9885]

=$Field

this would show the 'Dimension selected'

Not the value inside dimension.

You can use =$Field in title of your chart...

or =$FieldNo to show values...

Note: $Field should be a filter and $Field should be chart title to work properly.

Not sure if you looking for this?

[razoreth92]

Hi ,

I have done dynamic update of chart title for any filter selected .

you can make a filter with a combination of the dimensions and use the expression below:

use this expression in GENERAL TAB for TITLE

if([DIMENSION]='Add','Chart for ADD',
if([DIMENSION]='Update','Chart for Update','Chart')).

[Anil_Babu_Samineni]

I am not sure, What you are doing. Why can't you simplify like below

if(Match(DIMENSION, 'Add', 'Chart for ADD', 'Update'), 'Chart for Update', 'Chart')

[razoreth92]

I am setting up the title for the chart dynamically as per the filter suggested.

I have noticed the match function not working properly , therefore I used nested if, But your expression is more clear,
Thanks for improvement

[Anil_Babu_Samineni]

Can you show where this is not working?

[razoreth92]

LOAD Country,

STATE,

CITY,

SALES_TEAM

FROM

[DCR_HISTORY.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where match(SALES_TEAM, 'ARTHE','ONCO');

[Anil_Babu_Samineni]

I may say, this is straight forward. To check alternative dimension is not doable.