topic Re: How to set a default value for a list box in QlikView

How to set a default value for a list box

Fri, 27 Jun 2014 08:06:03 GMT

I'm using a list box as a way of selecting the financial year and period, but I always want it to default to the current financial year and period. How do I do this?

Thanks.

Re: How to set a default value for a list box

sasikanth — Fri, 27 Jun 2014 08:09:35 GMT

Nick , you can use

Always one selecte value option in list box properties

select a value in list box and then properties then check "always once selected value"

Re: How to set a default value for a list box

MK_QSL — Fri, 27 Jun 2014 08:16:01 GMT

You can achieve this by adding trigger to your document... Document Properties >> Trigger on fields

or Trigger on Sheet

What exactly looks like your list boxes?

Re: How to set a default value for a list box

Fri, 27 Jun 2014 08:19:10 GMT

Set up a Select Field Trigger through a button/sheet.

Define the Field Name

Search sting : =Year(Today())&Month(Today()) [According to the format of the field]

Regards,
Prabhu