Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cmaburns
New Contributor

Current Measure displayed in subtitle?

Hi,

I have a graph with a couple measures the user can select but i would like to (if possible) have the name of the selected measure in the sub title of the graph. Is this possible?

3 Replies

Re: Current Measure displayed in subtitle?

Yes, But you need some work around in script with Island table..

Life is so rich, and we need to respect to the life !!!
shraddha_g
Honored Contributor III

Re: Current Measure displayed in subtitle?

How you are selecting Measure?

Is it Alternate Measure or something?

OmarBenSalem
Esteemed Contributor

Re: Current Measure displayed in subtitle?

I'll invite not to use alternative measure to achieve this but as follow:

Let's assume you have 3 measures :

1) sum(measure1)

2) sum(measure2)

3) sum(measure3)

first thing to do :

in the script, create a new table:

Measures:

load * inline [

Measure, MeasureID

Measure1, 1

Measure2, 2

Measure3, 3

];

Once done, on your presentation, add the new field Measure as a filter :

Now, in you chart, you'll only ONE MEASURE:

if(MeasureID=1, sum(measure1),

if(MeasureID=2,sum(measure2),

if(MeasureID=3,sum(measure3)

)))


And as a title: ='The selected measure is : '&Measure

The user will only have to choose a Measure from the filter to have it shown in the graph.

Hope this was clear

Community Browser