Dates remove

[qlikview979]

Hi Experts,

Please find the attached file.

loveisfail‌stalwar1‌avinashelite‌@

I have two columns like Start Date,End date  like number of rows but i want to remove Saturday,Sunday Dates.

I want show to only Monday to Friday dates in List box.

Regards

Mahesh

[qlikview979]

sorry data missing

PFA

[luismadriz]

Hi,

This should help you. Do this with each list box

=Aggr(Only({<[Start Date]={"=Num(WeekDay([Start Date],0))<5"} >} [Start Date]),[Start Date])

Regards,

Luis

[luismadriz]

This show the reduction for Start Date for example:

[prma7799]

Like this???

[prma7799]

Please check this??

function:networkday

[Anil_Babu_Samineni]

I am sure, you will get bulk thread which are opened and status got closed related same, Just start community before come to thread.. Good luck

[qlikview979]

Sorry all ,i not am getting  correct output.

Here i am sending my original data.

I have 4 columns like

Event start date ,

Event start time,

Event Cancel date

Event Cancel time

here i need difference between

Event start date &Event start time - Event Cancel date & Event Cancel time. here i want remove the weekend days(Saturday ,Sunday)

,

ex:-

10/13/2017

23:00:00

10/16/2017

1:00:00

in this example Event start date &Event start time is 10/13/2017 23:00:00 and  14th,15th, is (Saturday,Sunday) no need to calculate this

and Event Cancel date& Event Cancel time 10/16/2017 1:00:00 A.M

Here example result is 2 hours.

Regards

Mahesh

[Anil_Babu_Samineni]

May be this?

NetWorkDays(TimeStamp(Date#([Event start date] & [Event start time],'MM/DD/YYYYhh:mm:ss')),

TimeStamp(Date#([Event Cancel date] & [Event Cancel time],'MM/DD/YYYYhh:mm:ss')))

OR

NetWorkDays(Date(Date#([Event start date] & [Event start time],'MM/DD/YYYYhh:mm:ss'),'DD-MM-YYYY'),

Date(Date#([Event Cancel date] & [Event Cancel time],'MM/DD/YYYYhh:mm:ss'),'DD-MM-YYYY'))

[qlikview979]

Hi anil,

Its not showing correct output.

Regards

Mahesh