Calculate WTD where week start is Monday and weekend is Saturday

[Aspiring_Developer]

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

[Mario_De_Felipe]

Hi @Aspiring_Developer, 

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

Best regards.

[williejacobs]

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.

[SunilChauhan]

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
];