Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 ?