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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Open dashboard to current month


I created a dashboard and Detail.  When I open them I want them to default to current month.

10 Replies
JonnyPoole
Former Employee
Former Employee

Hi Ed, 

Try this:

load a new field with the value 'current month'

Dates:

Load

     Date

from <>

change to:

CurMonth:

Load

     Date,

     'Current Month' as CurrentMonth

resident Dates

where monthname(Date)=monthname(Today());

After refreshing apply a selection on  CurrentMonth='Current Month'

Save/Publish the app.

Every time you refresh, 'Current MOnth' will only be associated with the dates from today's month.