Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Afaik there's no way to find out which alternative dimension is active.
=$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?
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')).
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')