Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

TAT Calculation without NULL Value

Hello, I need support to create a TAT calculation without consider the NULL value, normally should i use 

networksday(RecevingDate,ShippingDate) i need to have it only fo the value with shipping date not null. How can i do it? thanks Massimiliano

 

Tags (2)
Labels (2)
5 Replies
Highlighted

Re: TAT Calculation without NULL Value

Try this?

networksday(RecevingDate,If(Not IsNull(ShippingDate), ShippingDate))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Re: TAT Calculation without NULL Value

Thanks,i tried but i have every time the result -

Highlighted

Re: TAT Calculation without NULL Value

May be this

Only({<[Shipping date] *= {"*"}>} 
    NetWorksDay(RecevingDate, ShippingDate)
)
Highlighted
MVP
MVP

Re: TAT Calculation without NULL Value

Is this what you are after?

=If(Len(ShippingDate) > 0, networksday(RecevingDate,ShippingDate), null())

Will return null() if shipping date is null or an empty string.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor II
Contributor II

Re: TAT Calculation without NULL Value

i have again the error as result, maybe to help the support can be important say that i'm using this formula in the KPI.