Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
MK9885
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?

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

 

Highlighted

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
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
Highlighted

Re: Dynamic Chart Title Based on Alternative Dimension Selection

Can you show where this is not working?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
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');
Highlighted

Re: Dynamic Chart Title Based on Alternative Dimension Selection

I may say, this is straight forward. To check alternative dimension is not doable.
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)