topic Re: Count how many Tuesdays between 2 dates in QlikView

Count how many Tuesdays between 2 dates

richard_chilvers — Wed, 09 Feb 2022 09:18:16 GMT

Is there a smart way of counting the number of Tuesdays there are between 2 dates ?

Thanks

lironbaram — Wed, 09 Feb 2022 10:06:19 GMT

Hi
this expression should work for you

=sum(if(weekday(dateField)=2,1,0))

You need to replace "dateField" with your actual date field.

richard_chilvers — Wed, 09 Feb 2022 10:32:49 GMT

Thank you.

I guess I can use set analysis to define the date range I'm interested in ?

marcus_sommer — Wed, 09 Feb 2022 12:01:57 GMT

You may apply it in this way:

count({< [Weekday] = {2}>} [Date])

whereby weekday must exists as a native field within the data-model which is usually the case by using a master-calendar.

- Marcus