Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I count the amount of Fridays in a specific month?
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
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
Hi ,
Please find the answer in the below thread ,which is alreaady answered .
http://community.qlik.com/message/335201
Thanks & Regards
Yusuf Ali