Count of Friday's in every month

[jewseppie]

How do I count the amount of Fridays in a specific month?

[#2 · Accepted solution]

Hi,

You can use this expressions:

Count(if(WeekDay(FieldDate) = 4, FieldDate)) // 0=Monday, 1= Tuesday, 2=...

or

Sum(if(WeekDay(FieldDate) = 4, 1)) // More efficient

But, first select a month in your app.

Regards,

Ricardo

[#3]

Hi ,

     Please find the answer in the below thread ,which is alreaady answered .

http://community.qlik.com/message/335201

Thanks & Regards

Yusuf Ali