Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
poojashribanger
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
OmarBenSalem

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
OmarBenSalem

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