Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formula to find value between dates

HI,

Say, for instance, I had the following values:

DOC NUMBER:     DELIVERY NUMBER:     [CREATED ON]:     [PICKING DATE]:   

  124578                    A124578                         2012.06.01          2012.06.01    

                                B124578                          2012.06.01          2012.06.03

What kind of formula would I use to calculate the number of days the DOC_NUMBER takes to process inbetween [Created on] date and [Picking date]?

In this case I would looking for the value 2.

Any help would be greatly appreciated

Thanks

1 Reply
fosuzuki
Partner - Specialist III
Partner - Specialist III

How about:

max([Picking Date]) - min(Created On])