Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

Default Date on dashboard

Hi I have  a question here

In my dashboard I have to select a date on selection. I want to make a default date for dashboard for example I just want to show my data on current month - 1 . If now we are in November, I want to show the data on october. How can I do that? is it using expression?

1 Reply
Honored Contributor III

Re: Default Date on dashboard

If you have DateField/MonthStart Field then

Sum({<MonthStart = {"$(=date(addmonts(max(MonthStart),-1)))"}>}Value)

Community Browser