Count of Friday's in every month

[jewseppie]

Hi

How do I count the Fridays in a specific month?

[Clever_Anjos]

I think

if(WeekDay(MonthStart(vMonth))<=4,5,4)

will solve your need

[#3]

Hi ,

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

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

Thanks & Regards

Yusuf Ali

[VishalWaghole]

Hi

You should try this, hope this will solve your problem

Count(if(WeekDay(FieldName) = 4, FieldName))

Thanks and Regards,

Vishal Waghole.

[nilesh_gangurde]

hiiii,

you can have one more field in master calender which will give the flag as 1 if its friday for each date.

=iF(WildMatch(WeekDay(Fieldname ),'FRI'),1,0) as FIELD1,

and then make chart at front end having dimension as Month and expression as COUNT(DISTINCT FIELD1 )

[#6]

Try this

=Sum(If(WeekDay(Date) = 'Fri',1,0))

[er_mohit]

here you wirte in script

weekday(Datefield) as CalendarDayName

and in text object try this

count({<CalendarDayName={Fri} >} CalendarDayName)

as per your selection it will be count how many monday's are coming???