WTD AND PWTD CALUCLATE

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

Dear Team,

I stuck a requirement.i Want to Achive WTD AND PWTD IN EXPRESSION WITH SET ANALYSIS.

I achieved WTD Using this expression

Sum({<[Fiscal Year]=, [Fiscal Month]=, [Day Number], Link_Date={">=$(=Date(WeekStart(Max(Link_Date)),'DD/MM/YYYY'))<=$(=Date(Max(Link_Date),'DD/MM/YYYY'))"}>} Sale)

But i want to PWTD Means Previous week WTD.How is Caluclate. Kindly help me for solving

Re: WTD AND PWTD CALUCLATE

MK_QSL — Wed, 07 Jun 2017 08:42:10 GMT

Try

Sum({<[Fiscal Year]=, [Fiscal Month]=, [Day Number], Link_Date={">=$(=Date(WeekStart(Max(Link_Date),-1),'DD/MM/YYYY'))<=$(=Date(Max(Link_Date)-7,'DD/MM/YYYY'))"}>} Sale)

topic WTD AND PWTD CALUCLATE in QlikView

WTD AND PWTD CALUCLATE

Re: WTD AND PWTD CALUCLATE