topic Re: Calculate WTD where week start is Monday and weekend is Saturday in App Development

Calculate WTD where week start is Monday and weekend is Saturday

Aspiring_Developer — Wed, 07 Sep 2022 13:06:28 GMT

Hello All,

I have below data set :-

We need to calculate WTD for count(issue no) and here my week is starting from Monday and ends at Saturday. I need to show only week end dates and cumulative sum of entire week against that date like below :-

Can anyone please help ?

Thanks in advance

Re: Calculate WTD where week start is Monday and weekend is Saturday

Mario_De_Felipe — Tue, 20 Sep 2022 06:37:33 GMT

Hi @Aspiring_Developer,

you could try using a dimension WeekEnd([Issue Logged Date])

Best regards.

Re: Calculate WTD where week start is Monday and weekend is Saturday

williejacobs — Tue, 20 Sep 2022 06:37:51 GMT

Hi @Aspiring_Developer

You can achieve what you want to do by using the WeekEnd function.

Refer to this article

weekend - script and chart function ‒ QlikView

This refers to Qlik View but works the same for Qlik Sense.

In your case

Issue Logged Week - = WeekEnd ( Date , 0 , 0 )

Hope this helps.

Re: Calculate WTD where week start is Monday and weekend is Saturday

SunilChauhan — Tue, 20 Sep 2022 07:56:10 GMT

see the attached

Test:
Load *,weekDay(IssuelogDate) as Day,Num(weekDay(IssuelogDate)) as DayNum ,
Week(If(Num(weekDay(IssuelogDate))>=1 and Num(weekDay(IssuelogDate))<=6,IssuelogDate)) as Week inline [
IssuelogDate, Issuelogged
2022-09-06,292
2022-09-05,267
2022-09-04,4
2022-09-03,7
2022-09-02,258
2022-09-01,269
2022-08-31,279
2022-08-30,272
2022-08-29,15
2022-08-28,3
];