Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vsharma1
Partner - Creator
Partner - Creator

Last 5 years display on Clear All button

Hi,

I want to display last 5 years data on chart when user clicks on clear all button

 

 

 

1 Reply
NZFei
Partner - Specialist
Partner - Specialist

Then use set analysis to define the expressions to include last five years data.

 

For example:

=sum({<DateID={">=$(=yearstart(today(),-1))"}>}Sales)

 

Fei