Auto Select The Past 7 Days of Data On Open

[s10157754]

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

[Siva_Sankar · Accepted solution]

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]

Dear Kannagasabai,

Thanks for your solution and it works perfectly.

Best Regards,

QianNing