topic Re: Need help on previous Week's WTD set analysis on current year in QlikView

Need help on previous Week's WTD set analysis on current year

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

Hi,

I am using the below set analysis for WTD calculation:

sum({$<[Process Date]={">=$(=WeekStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Posting Amount USD])

But now I have to calculate Previous Week's(But not previous Year's WTD, so if it 4th week of year, I need 3rd weeks WTD) WTD and please give me the set analysis for that.

Thanks,

Sandip

Re: Need help on previous Week's WTD set analysis on current year

sunny_talwar — Wed, 07 Jun 2017 15:09:17 GMT

May be this

Sum({$<[Process Date]={">=$(=WeekStart(Max([Process Date]), -1)) <=$(=Date(Max([Process Date])-7))"}>}[Sales Posting Amount USD])

Re: Need help on previous Week's WTD set analysis on current year

antoniotiman — Wed, 07 Jun 2017 15:10:12 GMT

Hi,

may be

WeekStart(Max(Date),-1)

WeekEnd(Max(Date),-1)

Regards,

Antonio

Re: Need help on previous Week's WTD set analysis on current year

ziadm — Wed, 07 Jun 2017 15:16:54 GMT

Create a Calendar and use set Analysis to define all metrics based on the calendar filter.

if you are in the middle of the week and you want to compare with previous week then you have to compare number of days passed in the current week with same number of days of last week in order to have an equal comparative.

Compare Current Period with Previous Period Mistake

Re: Need help on previous Week's WTD set analysis on current year

VishalSingh18 — Thu, 27 Feb 2020 10:02:10 GMT

Thanks @sunny_talwar your formula helped for me

I really appreciate it boss i was trying such calculations from yesterday 11 am

thanks thank u it helped

Re: Need help on previous Week's WTD set analysis on current year

Dolly123 — Wed, 15 Feb 2023 09:08:07 GMT

i want week 1 current week 2 prev week3 prev week 4 prev in set analsyis

how we can achieve this

i will create the master calendar under that week connect with date date column table and then i can apply in set analysis