Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.