Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.