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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobJones
Creator
Creator

Use a variable to set which field a filter pane uses.

I want to use Qlik Variable Input to set a variable that decides what a field a filter pane is using. 

input to filter example.png

So the expression I am using in the filter pane is:

=if(vFocus = 'Case Processing Location', [Case Processing Location],
if (vFocus = 'Responsible Provider', [Responsible Provider]))

 

But this is not working.  Can anyone help me with the syntax or approach needed to make this work? Can a what field an object is using be changed this way?

1 Reply
adrien_marchadi
Partner - Contributor II
Partner - Contributor II

Hey Jacob,

Have you solved your issue ?

What I used in my late projecst was this syntax :

=[$(vFocus)]

or even better, as the previous syntax may introduce brackets in the filter tab :

=[$(='$(vFocus)')]

Capture d’écran 2020-10-14 180412.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

It work like a charm on tables, charts but I don't know why, in filter pane the field does not change when variable value is changed ...

Anyone have encountered this issue ?