Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How do I count the Fridays in a specific month?
I think
if(WeekDay(MonthStart(vMonth))<=4,5,4)
will solve your need
Hi ,
Please find the answer in the below thread ,which is alreaady answered .
http://community.qlik.com/message/335201
Thanks & Regards
Yusuf Ali
Hi
You should try this, hope this will solve your problem
Count(if(WeekDay(FieldName) = 4, FieldName))
Thanks and Regards,
Vishal Waghole.
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 )
Try this
=Sum(If(WeekDay(Date) = 'Fri',1,0))
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???