switching between measures

[#1]

Is there a quicker/more user friendly way to change to alternative measures in Qlik Sense rather than going through the exploration menu?

Thanks,

Nick

[OmarBenSalem]

Suppose I have 3 measures:

sum(CA)

sum(Quantity)

sum(Marge)

And I want to have all 3 measures in the same graphic.

You can add them as alternative measures as you're doing.

ANother way is to create an inline table in the script:

Let's call it:

Measures:

load * inline [

Measure

CA

QUANTITY

MARGE

];

Now, in our graphic we only have to use one measure:

sum(if(Measure='CA',

CA,

if(Measure='QUANTITY',

[Quantité] ,

if(Measure='MARGE',

Marge ))))

Add the new created field Measure as a filter object, and when you select a value, your measure will change with your selection:

Example:

I select CA: I get sum(CA) as a measure in my bar chart

I select Marge:(I get sum(marge) as a measure of my bar chart

Hope this helps

[#3]

Hi Omar,

Thanks for the reply, I will give this a try on Monday.

This may be a stupid question but how do you get the filter object to show the selection dots as you have above?

Thanks,

Nick

[OmarBenSalem]

It's an extension object; you'll find it attached.

To use an extension,

please put it under:

C:\Users\yourUser\Documents\Qlik\Sense\Extensions

then unzip it.

[diptiharia]

This is the easiest method i figured for myself. You create alternative measures and choose to display 'Labels and Title' in the Appearance section. One the sheet the toggle shows on the axis title (last screenshot)

Switching between Measures