topic Re: How can make multiple selections in listbox defaulty? in QlikView

How can make multiple selections in listbox defaulty?

Fri, 03 Oct 2014 07:07:58 GMT

how i have list box like year(2001,2002,2003,2004)

i need to select defautly 2001,2014?

how can put condition in list box?

alexandros17 — Fri, 03 Oct 2014 07:16:50 GMT

Use a trigger in the opening of the document or of the page, you can also use a trigger on a button

in all the cases use "Select in Field" as action, insert yhe field of the year (Ex. YearField)

and insert the search condition:

YearField>=2001<=2014

let me know

maxgro — Fri, 03 Oct 2014 07:28:15 GMT

see attachment for the trigger

Fri, 03 Oct 2014 07:58:42 GMT

am not able to see search string and field evnt trigger for on select and on change

rubenmarin — Fri, 03 Oct 2014 08:19:37 GMT

Hi sanjeev, Massimo image was from document properties, in the configuration menu

maxgro — Fri, 03 Oct 2014 08:44:00 GMT

yes, in menù

settings --> document properties--> triggers tab --> field event trigger

and the expression is

=if(GetSelectedCount( y )=0, '(2013|2014)', '(' & GetFieldSelections( y,'|' ) &')' )

if nothing selected (0) --> 2013 2014

else --> the selection (Getfieldselctions)

if you add the expression in a textbox you can see the search string