topic Re: How to get the most current date from a list. in QlikView

How to get the most current date from a list.

Tue, 16 Jun 2015 11:22:25 GMT

Hi All,

If I have a list of dates, lets say they are the date of every sale that a location of a business made. How would I display the number of days since the last sale? I understand that if I only had one date I could just use =[Sale Date]-Today() but since there are multiple dates I would want the 'most current date' - today().

So how do I create an expression to pull the most current date based on the selections of the chart? Like for instance if I had CT and NY selected I would want to subtract 4/5/2004 from today but if I only had MA selected I would want the expression to calculate 3/4/2005 from today.

Hope this makes sense and I appreciate the help.

Location	Sale Date
CT	12/1/2000
NY	1/2/2001
MA	1/2/2001
CT	4/5/2004
MA	3/4/2005

Re: How to get the most current date from a list.

maxgro — Tue, 16 Jun 2015 11:25:35 GMT

today() - max([Sale Date])

Re: How to get the most current date from a list.

MK_QSL — Tue, 16 Jun 2015 11:26:47 GMT

=Interval(Today() - Max([Sale Date]),'DD')

Re: How to get the most current date from a list.

qlikmsg4u — Tue, 16 Jun 2015 11:28:44 GMT

Date(today()-Max([Sale Date]))

Re: How to get the most current date from a list.

daniel_kusiak — Tue, 16 Jun 2015 11:33:45 GMT

=Today()-max([Sale Date])

Re: How to get the most current date from a list.

Tue, 16 Jun 2015 11:34:43 GMT

Hi,

Please go through the attachment.

Regards,

Jemimah

Re: How to get the most current date from a list.

Tue, 16 Jun 2015 14:47:44 GMT

Hi Jemimah,

Your DATEFORMAT in the script is : DateFormat='DD/MM/YYYY';

but the INLINE has MM/DD/YYYY.

I think the results will not be correct if format does not the match.

Regards

Kosmas