topic Variable as a list box or filter in QlikView

Variable as a list box or filter

Tue, 27 Nov 2012 20:42:15 GMT

I am using variable to display all the field values of a particular Field. But when I select any Fieldvalue trough Variable its not filtering Data based on selection.

I am using this function to display fieldvalues

concat(distinct STATE, ',')

Re: Variable as a list box or filter

Wed, 28 Nov 2012 06:27:57 GMT

HI pls refer this qvw file.

Re: Variable as a list box or filter

Fri, 27 Jun 2014 12:05:55 GMT

Thanks for this solution. This really helped.

Re: Variable as a list box or filter

sudeepkm — Fri, 27 Jun 2014 12:10:26 GMT

displaying the variable values in the list box does not make it selected. you need to apply Trigger on Variable to achieve that. Trigger action can should have the Select in Field to select the value of the variable to Field value.