Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ananyaghosh
Contributor 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

Tags (1)
4 Replies
zebhashmi
Valued Contributor

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

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

ananyaghosh
Contributor III

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

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
Contributor III

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

Hi Sandip

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

Please let us know the feedback.

Thanks

CY

zebhashmi
Valued Contributor

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

then maybe some tink like this

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