# 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
Did you mean:
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
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:

see if I select a weekday for example:

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

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:

see if I select a weekday for example:

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