Latest date to display in straight table for distinct products

[Anonymous]

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,

[tresesco]

Dimension: Product

Expression : Date(max(Date))

[Anil_Babu_Samineni]

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))

[#4]

Hi Nagesh Rao,

In straight table put Dimension as Product and expression as =date(max(Date)).

Regards,

Sanya Chauhan

[Anonymous]

Hi Anil,

My date format 'D/M/YYYY';

Thanks,

[Anil_Babu_Samineni]

Change it to

SET DateFormat='DD/MM/YYYY';

and try