topic Re: please give me answer in QlikView

please give me answer

Sat, 27 Apr 2013 01:57:51 GMT

how can we get number of fridays in june month

jagan — Sat, 27 Apr 2013 05:33:28 GMT

Hi Sravani,

While loading the data do this

Data:

Load

WeekDay(DateFieldName) AS Day

FROM DataSource;

Now in expression use this set analysis expression

=Count({<Day={'Fri'}>} DISTINCT DateFieldName)

Hope this helps you.

Regards,

Jagan.

nilesh_gangurde — Sat, 27 Apr 2013 16:13:12 GMT

Please find the attachement for Solution.

-Nilesh