topic Re: Workday Function from Excel to qliksense in QlikView

Workday Function from Excel to qliksense

Prasad1318 — Mon, 06 Jun 2022 11:31:57 GMT

Hello

I have a situation, where I have to findout working dates.

I have a field ‘Date’ ,

In excel Workday(Date,-1, Bankholys) as WD_ Date. I want to replicate WD_Date in qliksense

Example - 1.Date - 07/01/22 , Friday then WD_Date - 06/01/22

2. Date - 10/01/22 , Monday then WD_Date - 07/01/22

kindly help me on this

Regards,

Prasad.

Re: Workday Function from Excel to qliksense

maxgro — Mon, 06 Jun 2022 12:29:21 GMT

try with lastworkdate function

The lastworkdate function returns the earliest ending date to achieve no_of_workdays (Monday-Friday) if starting at start_date taking into account any optionally listed holiday. start_date and holiday should be valid dates or timestamps.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/lastworkdate.htm

Re: Workday Function from Excel to qliksense

Prasad1318 — Mon, 06 Jun 2022 14:35:27 GMT

Thanks Maxgro for the reply,

How can we give -1 i mean negative no. Of working date in the last work date function, actually, I have given function as follows

LastWorkdate(Date,1,$(vBankhlyd))-1

now if Date - 10/01/2022 Monday then WD_Date - 09/01/2022 Sunday is coming instead 07/01/2022 - Friday

It is working fine for Tuesday, Wednesday, Friday

is it right what I have written?

Thank you

Regards,

Prasad

Re: Workday Function from Excel to qliksense

Prasad1318 — Mon, 06 Jun 2022 14:37:59 GMT

Sry It is working for Tuesday Wednesday Thursday Friday except Monday

Re: Workday Function from Excel to qliksense

maxgro — Mon, 06 Jun 2022 16:25:21 GMT

try with

FirstWorkDate(Date-1,1)

Re: Workday Function from Excel to qliksense

Prasad1318 — Tue, 07 Jun 2022 06:34:00 GMT

Thank you Maxgro for the solution, it is working