Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a series of dates, eg.:
If I select a particular date, I want to find the date immediately prior to that date.
For example:
Obviously, "Date - 1" won't work. Is there a way to do this in QlikView?
You need to create DateID for this..
SET DateFormat='YYYYMMDD';
SET TimestampFormat='YYYYMMDD hh:mm:ss[.fff]';
Data:
Load * Inline
[
DateField
20160628
20160627
20160623
20160620
];
Left Join (Data)
Load Distinct DateField, AutoNumber(DateField) as DateID Resident Data
Order By DateField;
Now use below...
=Max({<DateField, DateID = {'$(=Max(DateID)-1)'}>}DateField)
Hi
use Below() or Above() function
like Below(dates) ? **Below(yourdatefield)
Try
=Max({<Date={'<$(=Max(Date))'}>} Date)
Excellent !
Thanks Manish.
Regards,
Antonio