Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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))