Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

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
Highlighted
MVP
MVP

Re: List box selection based on variable

Use variable event trigger like in attached sample.

Highlighted

Re: List box selection based on variable

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: List box selection based on variable

Hi,

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

Regards,

Jagan.

Highlighted

Re: List box selection based on variable

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