How to get the -ve values in networkdays in qliksense

[Anonymous]

We are getting the + values in networkdays in qliksense .

How to get the - values in networkdays

[Chanty4u · Accepted solution]

this might give you some idea

Negative values in networkdays

[Anonymous]

Thank you for replying.

i have tried this expression earlier.

if(Date(Date_1)>Today(),If((NetWorkDays(Date(Date_1),Today()))<10,'0-10',If((NetWorkDays(Date(Date_1),Today()))<20,'10-20','+20')),

If(((NetWorkDays(Date(Date_1),Today()-1))<10)*-1,'0-(10)',

If(((NetWorkDays(Date(Date_1),Today()-1))<20)*-1,'(10)-(20)','(20)+')))

the issue is we are +20 values are coming in (20)+.