Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You have the ability to create an expression for your chart title.
Try using this in your expression:
GetCurrentField([group name])
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.
That's possible when u create an hiearchic dimension, isn't it?
I guess it's not possible natively.
take a look here https://qlikcommunity.qliktech.com/thread/259990
What is 'group name' here?
That wouldn't work if I'm using the normal Alternative Dimensions feature for charts, right?
Nope.. u'll have to create ur own dimensions/measures to select
How do you switch between Dimension or Measure?
Is it via Cyclic group?
Perfect! thank you!
