Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Calculating weekdays count in a month

i have a date column and i want number of completed weekdays for a particular date

i.e.

1/12/2018--sat--1

2/12/2018--Sun--1

3/12/2018--Mon--1

......

17/12/2018--Mon--3

18/12/2018--Tue--3

.....

31/12/2018--Mon--5

 

i want to dynamically get the count of weekdays for a day till today

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Suppose u have a date field, a weekday field and a month field:

 

use this expression:

aggr(rangesum(above( count({1}WeekDay),0,RowNo())),Month,WeekDay,MyDate)

 

result:

Capture.PNG

 

see if I select a weekday for example:

Capture.PNG

 

If I select a date: ; exaù^me 27/12/2018; I'd expect Jeu(thirsday) and 4 :

Capture.PNG

View solution in original post

1 Reply
Highlighted
Partner
Partner

Suppose u have a date field, a weekday field and a month field:

 

use this expression:

aggr(rangesum(above( count({1}WeekDay),0,RowNo())),Month,WeekDay,MyDate)

 

result:

Capture.PNG

 

see if I select a weekday for example:

Capture.PNG

 

If I select a date: ; exaù^me 27/12/2018; I'd expect Jeu(thirsday) and 4 :

Capture.PNG

View solution in original post