topic Re: How to get last week value in set analysis?? in QlikView

How to get last week value in set analysis??

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Team,

I could get value for current week sale , but in my scenario i need to get value for last week sale so i need to use [week date] - 7 in my set analysis !

Please share your thoughts!!

Re: How to get last week value in set analysis??

andrey_krylov — Mon, 03 Sep 2018 19:16:29 GMT

Hi, Ashok. Try this set analysis

{< [YourDateField] = {">=$(=WeekStart(Today() - 7))<=$(=WeekEnd(Today() - 7))"} >}

Re: How to get last week value in set analysis??

Anonymous — Tue, 04 Sep 2018 09:45:26 GMT

Thanks for your response Andrey! will try and get back to you!

Re: How to get last week value in set analysis??

Michiel_QV_Fan — Tue, 04 Sep 2018 14:30:09 GMT

Do you use a master calendar?

Add a week id to that with autonumber: autonumber(Year(Date)&Week(Date)) as Week_ID.

this will give a sequencial number starting from the first date (be careful with week 53, is it in the old year or the new .....)

Use this in your set analysis:

Sum({<Week_ID = {"$(=max(Week_ID)-1)"}>}whatever)

Re: How to get last week value in set analysis??

venkym1997 — Thu, 21 Sep 2023 10:58:34 GMT

Hi Andrey ,

I have scenario where we don't have dates for weekends and I want calculate average for last 7 data points

The above expression will work if dates are in sequence like 3,4,5,6,7,8,9

In my case dates are like 3,4,5,6,9,10,11 , how can I achieve 7 days avg here?