Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to assign default selection in listbox when qlikview file opens

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

2 Replies
Not applicable
Author

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

Not applicable
Author

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.