Expression for Next 5 Days (skipping weekend)

Tue, 21 Jun 2016 04:25:16 GMT

Hi Guys,

I am trying to create a straight table with one dimension as 'Sales Person' and then I want 5 expression columns which should show the follow ups for next 5 days (working days only)

In my data model, I have a follow up date field against each order Id.

Currently I am using an expression like this..

=count(DISTINCT(if([Follow up Date] = Date(Today()), OrderId)))

=count(DISTINCT(if([Follow up Date] = Date(Today()+1), OrderId)))

=count(DISTINCT(if([Follow up Date] = Date(Today()+2), OrderId)))

=count(DISTINCT(if([Follow up Date] = Date(Today()+3), OrderId)))

=count(DISTINCT(if([Follow up Date] = Date(Today()+4), OrderId)))

And labels like this

=Weekday(Today())

=Weekday(Today()+1)

=Weekday(Today()+2)

=Weekday(Today()+3)

=Weekday(Today()+4)

But doing this also including Saturday and Sunday. How can I skip Weekend so if today is Tuesday then it will show Monday as the fifth day instead of Saturday!

Re: Expression for Next 5 Days (skipping weekend)

varshavig12 — Tue, 21 Jun 2016 04:31:50 GMT

Try

lastworkdate()

Re: Expression for Next 5 Days (skipping weekend)

varshavig12 — Tue, 21 Jun 2016 04:36:23 GMT

Today's date: LastWorkDate(today(),1)

LastWorkDate(today(),2)

LastWorkDate(today(),3)

LastWorkDate(today(),4)

LastWorkDate(today(),5)

LastWorkDate(today(),6)

Re: Expression for Next 5 Days (skipping weekend)

Tue, 21 Jun 2016 04:43:40 GMT

Thanks mate got what I wanted

topic Re: Expression for Next 5 Days (skipping weekend) in QlikView

Expression for Next 5 Days (skipping weekend)

Re: Expression for Next 5 Days (skipping weekend)

Re: Expression for Next 5 Days (skipping weekend)

Re: Expression for Next 5 Days (skipping weekend)