Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bhawana
Contributor II
Contributor II

last 5 weeks of data variable

Hi All,

I have to create a variable that has complete last 5 weeks of data and start date must always be saturday even if today is mid day of the week. I have a date field in the app.

How can I do this?

 

Thanks

in advance

 

 

2 Replies
dilipranjith
Partner
Partner

not completely clear on your requirement.

please elaborate with example.

to get the previous saturday to today you can use below expression

Date(WeekStart(today())-1,'MM/DD/YYYY')

dwforest
Specialist II
Specialist II

Taking what Dilipranjith provided:

Date(WeekStart(today())-1,'MM/DD/YYYY') - 35  //7*5 = 35 days