Dynamic chart naming based on selected measure

[Anonymous]

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?

[rittermd]

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

Try using this in your expression:

GetCurrentField([group name])

[OmarBenSalem]

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]

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

[agigliotti]

I guess it's not possible natively.

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

[Anonymous]

What is 'group name' here?

[Anonymous]

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

[OmarBenSalem]

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

[passionate]

How do you switch between Dimension or Measure?

Is it via Cyclic group?

[DevelopCal]

Perfect! thank you!