Filter a chart by measure

[guidocobs]

Hello Everybody,

I have a visual with several measure (bars and line).

I want to let the user filter by them.

Can you please help?

I have found in another topic line an qvf file, but I am using Qlik Sense Enterprise and I don't know hot to open it

(I am not able access to QMC)

Many thanks for your support

[JordyWegman]

Hi Guido,

In Qlik you cannot select measures. This is because of the way the associative engine works. You can only select dimensions. What do you want to achieve? That users select one measure and you will get that measure for all months?

Jordy

Climber

[KeaneGleeson]

Are you wanting to allow users to toggle on and off measures on a chart? I have set this up before by creating a toggle table:

Toggle:

load * inline [

%toggle_field

measure1

measure2

...];

Then, on the front end I put that toggle field in something like the variable input object (I like using the SimpleFieldSelect extension). In the chart, I add a condition to each measure to either show or hide it:

if(SubStringCount(GetFieldSelections([%toggle_field,'|'),'measure1')>0,

<measure1 Expression>

)

Example look of it: