Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dilipkumard12
New Contributor II

How to get the -ve values in networkdays in qliksense

We are getting the + values in networkdays in qliksense .

How to get the - values in networkdays

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: How to get the -ve values in networkdays in qliksense

this might give you some idea

Negative values in networkdays

2 Replies
sureshqv
Esteemed Contributor III

Re: How to get the -ve values in networkdays in qliksense

this might give you some idea

Negative values in networkdays

dilipkumard12
New Contributor II

Re: How to get the -ve values in networkdays in qliksense

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)+.