Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

drunk8gods
New Contributor

Dynamic Chart Title Based on Alternative Dimension Selection

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.

Tags (1)
8 Replies

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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


talk is cheap, supply exceeds demand
Khan_Mohammed
Honored Contributor II

Re: Dynamic Chart Title Based on Alternative Dimension Selection

=$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
New Contributor

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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')).

 

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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
New Contributor

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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

Re: Dynamic Chart Title Based on Alternative Dimension Selection

Can you show where this is not working?
razoreth92
New Contributor

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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');

Re: Dynamic Chart Title Based on Alternative Dimension Selection

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