Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can i display current month and year by default when report is loading

Hi,

How can i display current month and year, when my report is loading

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add Select in Field actions to the OnOpen document trigger for the year and month fields to select the current year and month in those fields when the document is opened. The search strings would be something like year(today()) and month(today()).

or... is all you want a text box that displays the current year and date: ='The current month and year are ' & month(today()) & ' in ' & year(today())


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

... or if you're interested in the month and year of the last data load, use:
year(ReloadTime())

month(ReloadTime())