Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER 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
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
OmarBenSalem
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