If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have 4 years of data and my data is update every day. I have created dashboard. I want show last one year data when page open.
ex: If i open app on 04-12-2018, i want show dash board from 05-12-2017 to 04-12-2018
If i open app on 05-12-2108 , I want show dash board from 06-12-2017 to 05-15-2018
How can i create triggers for that in Qliksense as well as i create the filters for date, when i select the date the dashboard have to show that date.
Can you please suggest me best way,
hi
in your Date field (let assume the field name is Date)
insert this expression :
=Date>addyears(max(Date),-1)
now create a new bookmark call it Opening selections
on the new bookmark right click and set it as default bookmark
Where i have to write the expression in the book mark in the qliksnese.