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: 
Anonymous
Not applicable

Use Variable on "Select in Field" Sheet Trigger

Hi,

I have a question about using variable on select in field trigger.

I have two variabel:

1. vMin = 201701

2. vMax = 201703

I want to select yearweek field by using trigger, so the selected value must be between 201701 until 201703 (201701, 201702, 201703)

i've already try using this expression

>=$(vMin) <=$(vMax)

trigger.PNG

But it doesn't work.

Really need your help

Thanks in advance.

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi Chou,

Try this as search string.

='>=$(vMin)<=$(vMax)'

View solution in original post

3 Replies
tamilarasu
Champion
Champion

Hi Chou,

Try this as search string.

='>=$(vMin)<=$(vMax)'

Anonymous
Not applicable
Author

Hi Tamil,

Thanks for your answer, It solved my problem perfectly

tamilarasu
Champion
Champion

Great. Have a nice day Chou.