topic Re: Minus 30 work days in QlikView

Minus 30 work days

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

I created the following variable: v30DaysOld = Date((Today()-30))

It does calculate 30 days earlier but I want it to calculate 30 work days earlier.

I do have a Field called "DAY_TYPE" that includes WorkDay, Holiday, Off_Friday and Weekend.

So I have been trying this on my variable: v30DaysOld = ({$<DAY_TYPE={'WorkDay'}>}Date(Today()))-($<DAY_TYPE={'WorkDay'}>}30)

I know I am doing something wrong here. Can anyone give me some guidance on how I can write this statement properly so that my variable will only minus 30 work days instead of minus 30 days?

Re: Minus 30 work days

vishsaggi — Wed, 09 Aug 2017 19:26:12 GMT

May be Try this?

LET v30DaysOld = Only( {$< DAY_TYPE = {'WorkDay'}>} Date(Today()) ) - 30 ;

Re: Minus 30 work days

sunny_talwar — Wed, 09 Aug 2017 19:31:21 GMT

May be use FirstWorkDate() or LastWorkDay() function here

firstworkdate ‒ QlikView

lastworkdate ‒ QlikView

Re: Minus 30 work days

sasiparupudi1 — Thu, 10 Aug 2017 01:02:38 GMT

Hi Amber

Please share your calendar or date fields.

The set analysis on constant like 30 does not work

And there is nothing to filter when you select today ()

Regards

Sasi

Re: Minus 30 work days

omkarvamsi — Thu, 10 Aug 2017 10:19:10 GMT

Please try as below;

1)write below let statement in script editor.

let vToday=today();

2)run the script

3)take a text box and try the below expression:

=makedate(year(today()),month(AddMonths(today(),-1)),(day(vToday)-30)*(-1))