Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

s10157754
Contributor

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
Highlighted
Siva_Sankar
Honored Contributor

Re: Auto Select The Past 7 Days of Data On Open

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

2 Replies
Highlighted
Siva_Sankar
Honored Contributor

Re: Auto Select The Past 7 Days of Data On Open

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
Contributor

Re: Auto Select The Past 7 Days of Data On Open

Dear Kannagasabai,

Thanks for your solution and it works perfectly.

Best Regards,

QianNing

Community Browser