topic how to assign default selection in listbox when qlikview file opens in QlikView

how to assign default selection in listbox when qlikview file opens

Wed, 11 May 2011 06:34:25 GMT

Hi Everyone,

Hi i am having date field in listbox, when user opens the qlikview file then the default selection in listbox should be the current date how can i work on this

Please share your ideas.

Thnks

how to assign default selection in listbox when qlikview file opens

Wed, 11 May 2011 07:05:26 GMT

Hi,

You can add trigger for that

Sheet Properties---->Triggers---->On Activate Sheet----> Add Action----> Action Type (Selection) & Action (Select In Field) ----->Field ( add your date field) & Search String (today())

Please check your date format.

Thanks & Regards

how to assign default selection in listbox when qlikview file opens

Wed, 11 May 2011 08:46:19 GMT

Go to

Sheet Properties>>Triggers>>On Activate Sheet>> Add Action>> Action Type -Selection

Action -Select In Field >>

Field - Date

Search String - =date(today(),'DD/MM/YYYY')

'DD/MM/YYYY' is the format of the date ,I have in the 'Date' field.