Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adwitiya
Contributor

Dynamic chart naming based on selected measure

I have a bar chart with the option to select between multiple alternative measures and dimensions.

I want to change the chart name based on the measure and dimension I select. Is it possible?

8 Replies
rittermd
Honored Contributor

Re: Dynamic chart naming based on selected measure

You have the ability to create an expression for your chart title.

Try using this in your expression:

GetCurrentField([group name])

omarbensalem
Esteemed Contributor

Re: Dynamic chart naming based on selected measure

Yes , it is possible but not with Alternative measures; instead :

1) create an inline table as follow:

Dimensions:

load * inline [

Dimension, DimID

Dim1, 1

Dim2, 2

];

2) add this newly created Dimension field as a filter pane in ur sheet

3) change ur dimension in your chart, from al-ternative dimensions to:

if(DimID=1, YourFirstDimension, YourSecondDimension)

with that, based on the selections u make in the Dimension field, one of your Actual dimensions will be the shown one in your chart.

4) In the title, :

'Measure by '&Dimension


The same logic can be replicated with your Alternative Measures.

omarbensalem
Esteemed Contributor

Re: Dynamic chart naming based on selected measure

That's possible when u create an hiearchic dimension, isn't it?

agigliotti
Honored Contributor II

Re: Dynamic chart naming based on selected measure

I guess it's not possible natively.

take a look here https://qlikcommunity.qliktech.com/thread/259990

adwitiya
Contributor

Re: Dynamic chart naming based on selected measure

What is 'group name' here?

adwitiya
Contributor

Re: Dynamic chart naming based on selected measure

That wouldn't work if I'm using the normal Alternative Dimensions feature for charts, right?

omarbensalem
Esteemed Contributor

Re: Dynamic chart naming based on selected measure

Nope.. u'll have to create ur own dimensions/measures to select

passionate
Valued Contributor

Re: Dynamic chart naming based on selected measure

How do you switch between Dimension or Measure?

Is it via Cyclic group?