Number of days between 2 dates

[#1]

Hi.

I am very new in Qlikview, I would like some assistance calculate  number of days between 2 dates and exclude nulls in that expression.

I did this on my expression in  straight table with Supplier as my dimension

date#(GirGrvOrderDate-GirPrefDelDate)  however its diving nulls on some values.. how can I remove nulls on expression

my goal is to trace how many days was my supplier late for delivery

Thanks

Deli(SA)

[arulsettu]

try this

Date(interval(GirGrvOrderDate-GirPrefDelDate))

[hic]

Just calculate

  GirPrefDelDate - GirGrvOrderDate

The Date() and Interval() functions are formatting functions, and you don't need to format this number. The above expression will return an integer - the number of days - which is what you want.

HIC

[Anonymous]

Hi Deli ,

you can also use

Interval(date(GirGrvOrderDate)-date(GirPrefDelDate),'d') as Days

here you will get the difference in days

Thanks

BKC

[hic]

Just a small note:

The Interval() function and the Date() function are both formatting functions, which means that they don't change the numeric value of the field. Hence, it is totally unnecessary to nest one function inside the other. The following two will return identical results:

   Interval(date(GirGrvOrderDate)-date(GirPrefDelDate),'d')

   Interval(GirGrvOrderDate-GirPrefDelDate,'d')

HIC

PS

Since the delivery date usually happens after the order date, I think that GirPrefDelDate-GirGrvOrderDate is better than GirGrvOrderDate-GirPrefDelDate...

[Anonymous]

Thank you Henric

[pradnyat]

Hi Deli,

If u want to calculate no. of working days, then use networkdays function.

  networkdays ('2007-02-19', '2007-03-01') returns 9.

Use Networkdays(GirGrvOrderDate, GirPrefDelDate).

If you want to calculate overall days then just use, GirGrvOrderDate-GirPrefDelDate.

Hope this will help you.

[#8]

Thanks Henric

GirPrefDelDate-GirGrvOrderDate  does give me the integer I want, however there are nulls  on other suppliers. how do I suppress nulls on expressions

Deli

[#9]

This does work  thanks

however how do I suppress nulls on expressions because im not interested in those. I need numbers only.

Deli

[pradnyat]

Check 'Supress when value is NULL' option for Suppliers dimension.