Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

If you have DateField/MonthStart Field then

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