Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Heny
Contributor III
Contributor III

Filter pane using measure field names

Hi,

I would like to create a filter pane that lets the user choose which measure to show on the chart

I tried following the instructions given on this post (the second option):

https://community.qlik.com/t5/Qlik-Education-Discussions/Any-way-I-can-set-up-a-Filter-pane-on-Measu...

but it's not working. 

I thing the problem is somewhere with the variable i added as I was able to add a filter pane with the values I wated, but when I add a KPI, for example, and I assign the variable to it, it does not return the correct value. 

I'm using Qlik Sense Enterprise

 

1 Solution

Accepted Solutions
ajaykakkar93
Specialist III
Specialist III

Hi, 

Try this solution i hope it will help,

Step 1 :
Make inline table i.e. the list of your measure name
Measures_List:
load * inline [
MesList
Mes1
Mes2
Mes3
];

Step 2 :
Add Fiels to a filter pane

Step 3 :
compare your selected value & switch measure as condition satisfy
Or
you can add calculated condition to show error if needed

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

View solution in original post

1 Reply
ajaykakkar93
Specialist III
Specialist III

Hi, 

Try this solution i hope it will help,

Step 1 :
Make inline table i.e. the list of your measure name
Measures_List:
load * inline [
MesList
Mes1
Mes2
Mes3
];

Step 2 :
Add Fiels to a filter pane

Step 3 :
compare your selected value & switch measure as condition satisfy
Or
you can add calculated condition to show error if needed

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting