Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
javier_garcia_g
New Contributor III

Filter with measures like values. Select a measure

Hello.

I would like create a filter where I could choose between several measures, with the end to show in a pivot table or chart only a measure or other.

In this moment, I have this:

medidas.PNG

In this table, to different of a dimensions, the measures (Medidas) can not be selected. So always "Pasajeros" and "Pasajeros-km" are showed.

I can't want unpivot the table. So that isn't a option.

Is posible create a table with the measures and link with actual table?

Can someone help me?

Thanks and regards.

2 Replies
MVP & Luminary
MVP & Luminary

Re: Filter with measures like values. Select a measure

Yes, you can add an extra table in your script with the expressions:

Measures:

LOAD * INLINE [

Label, Expression

Sum of Sales, sum(Sales)

Average Sales, avg(Sales)

];

After reloading you can add a filter pane in your app for the Label field. And change the measure in your pivot table with =$(=Only(Expression)) as expression and =Only(Label) as the label


talk is cheap, supply exceeds demand
javier_garcia_g
New Contributor III

Re: Filter with measures like values. Select a measure

Hello.

Thanks by your answer. But It don't work like I hope. Now when I choose one option, this is duplicate (obvious), and when I choose 2 or more, nothing.

The label isn't changed.

medidas_1.PNG

And

medidas_2.PNG

Is posible have the both columns (or any), and one of them hide/show when I choose a mesaure? Like when you select a opcion in a filter by dimension.

Thank you and regards.