Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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 | 
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		today() - max([Sale Date])
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		today() - max([Sale Date])
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=Interval(Today() - Max([Sale Date]),'DD')
 qlikmsg4u
		
			qlikmsg4u
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Date(today()-Max([Sale Date]))
 
					
				
		
 daniel_kusiak
		
			daniel_kusiak
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=Today()-max([Sale Date])
 
					
				
		
Hi,
Please go through the attachment.
Regards,
Jemimah
 
					
				
		
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
