Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Auto Select The Past 7 Days of Data On Open

Dear Qlikview Experts,

Currently I was using the below code to auto select the data for previous day on open. Is there a way for us to auto select the past 7 days of data on open? Thanks for your help in advance!

=(date((Today()-1),'DD-MMM-YYYY'))

Best Regards

QianNing

1 Solution

Accepted Solutions
Siva_Sankar
Master II
Master II

Hi

You may try somehting like this expression ='>='&Date(today()-7)&'<='&Date(today()) .


Or you can handle it in the script and create a field and use it in trigger Last x days filter not working

-Siva

View solution in original post

2 Replies
Siva_Sankar
Master II
Master II

Hi

You may try somehting like this expression ='>='&Date(today()-7)&'<='&Date(today()) .


Or you can handle it in the script and create a field and use it in trigger Last x days filter not working

-Siva

s10157754
Creator III
Creator III
Author

Dear Kannagasabai,

Thanks for your solution and it works perfectly.

Best Regards,

QianNing