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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Set past one year data default when app open..

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,

Labels (1)
2 Replies
lironbaram
Partner - Master III
Partner - Master III

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

 

Kohli
Creator II
Creator II
Author

Where i have to write the expression in the book mark in the qliksnese.