Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have data like below
Product | Date |
A | 25/4/2017 |
A | 1/5/2017 |
A | 8/5/2017 |
B | 7/5/2017 |
B | 3/5/2017 |
C | 3/3/2017 |
C | 3/2/2017 |
C | 6/5/2017 |
want to display in straight table latest date by product wise like below
Product | Date |
A | 8/5/2017 |
B | 7/5/2017 |
C | 6/5/2017 |
Thanks,
Dimension: Product
Expression : Date(max(Date))
How is you date format in Qlikview Environment
SET DateFormat='DD/MM/YYYY';
And, In straight table just use this and go to presentation do Suppress Values to show all values
Date(Max(Dates))
Hi Nagesh Rao,
In straight table put Dimension as Product and expression as =date(max(Date)).
Regards,
Sanya Chauhan
Hi Anil,
My date format 'D/M/YYYY';
Thanks,
Change it to
SET DateFormat='DD/MM/YYYY';
and try