Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
soha1902
Creator
Creator

List box selection based on variable

Hi All,

I have one Year flter (List Box) which contains values 2010,2011,2012,2013 and 2014. One variable which is holding the value of input box. Now my requirement is if user enter any year value in input box then that year will select in Year filter.

Please help to find this.

Thanks

4 Replies
tresesco
MVP
MVP

Use variable event trigger like in attached sample.

its_anandrjs

Hi,

1. First create any variable let say vYearSelect

2. Create the Input box with this variable select

3. In the list box expression properties write expression

           =if( Year = $(vYearSelect) , Year )

Regards,

Anand

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution, used one variable and field event triggers in Document Properties -> Triggers

Regards,

Jagan.

its_anandrjs

Hi Soha,

Actually write this expression in the list box for list box work in the null value also, also field event triggered is same

1. First create any variable let say vYearSelect

2. Create the Input box with this variable select

3. In the list box expression properties write expression

=if(Year = vYearSelect, Year,if(Len(vYearSelect) <= 1,Year))

Regards

Anand