topic Re: List box selection based on variable in QlikView

List box selection based on variable

soha1902 — Mon, 24 Nov 2014 07:18:39 GMT

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

Re: List box selection based on variable

tresB — Mon, 24 Nov 2014 07:25:41 GMT

Use variable event trigger like in attached sample.

Re: List box selection based on variable

its_anandrjs — Mon, 24 Nov 2014 07:27:54 GMT

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

Re: List box selection based on variable

jagan — Mon, 24 Nov 2014 07:36:41 GMT

Hi,

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

Regards,

Jagan.

Re: List box selection based on variable

its_anandrjs — Mon, 24 Nov 2014 07:49:35 GMT

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