Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

how can i calculated the number of a weekday in a date range?

Hi,

I have created a date filed and assign the value to a variable vDate and I have a date range also and assign the value to a variable vRANGE. Now if the use select vDate as 24/1/2018 and range as 9, the I have calculate the number of Wednesday which is actually the creation date in that range.

SO if vDate is 24/1/2018 and vRange is 9, the the date range is 15/1/2018 To 24/1/2018 and I need to calculate how many weekday is in between in that date range. in this case the weekday is Wednesday as because 24/1/2018 is Wednesday.

so any idea will be appreciated.

Thanks,

Sandip Ghosh

4 Replies
zebhashmi
Specialist
Specialist

=networkday('15/1/2018', '24/1/2018')

ananyaghosh
Creator III
Creator III
Author

it will give me the date difference between 2 dates, but I want to know the number of Wednesday in between 2 days.

Thanks,

Sandip

ychaitanya
Creator III
Creator III

Hi Sandip

Use networkdays($(vDate),$(vDate)+(vRange)).

Please let us know the feedback.

Thanks

CY

zebhashmi
Specialist
Specialist

then maybe some tink like this

count({<Date=WeekDay(vDate)>}vRange))