topic Re: Finding count of all Sundays in the Given Date Range in QlikView

Finding count of all Sundays in the Given Date Range

Wed, 07 Sep 2011 05:57:15 GMT

Hi All,

I want to Find Count of all Sundays in the Given Data Range i.e From And To Date.

Eg.

From Date To Date

1-Sep-2011 20-Sep-2011

Nos Of Sundays = 3

How Can I achieve this ?

gandalfgray — Wed, 07 Sep 2011 06:49:05 GMT

Hi Nandkishor

Try this (replace 'sun' to what you use):

=sum({<Date={">=$(FromDate) <=$(ToDate)"}>} if(Weekday(Date)='sun', 1, 0))

hth/gg

its_anandrjs — Wed, 07 Sep 2011 07:02:29 GMT

Hi,

If it is single date column try this out for date column

=sum( if ( Weekday ( YourDateField ) = 'Sun', 1, 0 ) )

Regards,

Anand