Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Latest date to display in straight table for distinct products

Hi All,

I have data like below

 

ProductDate
A25/4/2017
A1/5/2017
A8/5/2017
B7/5/2017
B3/5/2017
C3/3/2017
C3/2/2017
C6/5/2017

want to display in straight table latest date by product wise like below

 

ProductDate
A8/5/2017
B7/5/2017
C6/5/2017

Thanks,

5 Replies
tresesco
MVP
MVP

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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Hi Nagesh Rao,

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


Regards,

Sanya Chauhan


Anonymous
Not applicable
Author

Hi Anil,

My date format 'D/M/YYYY';

Thanks,

Anil_Babu_Samineni

Change it to

SET DateFormat='DD/MM/YYYY';

and try

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful