How to show max date and its Sales?

https://community.qlik.com/thread/316205

Use DATE#,Left functions. Search in Qlikview Help

Data:

Name Date Sales
Modi 07/10/2018 12:00:00 AM 9
Babu 11/09/2018 12:00:00 AM 3
Name3 20/07/2018 12:00:00 AM 5
Name1 20/09/2018 12:00:00 AM 0
Name2 21/08/2018 12:00:00 AM 0
Ramesh 21/08/2018 12:00:00 AM 2
John Saida 30/09/2018 12:00:00 AM 3
Gopi Raju 31/08/2018 12:00:00 AM 2

Check this thread:

https://community.qlik.com/thread/315995

Data:
LOAD * INLINE [
Name,Date,Sales
Gopi Raju,31/08/2018 12:00:00 AM,2
John Saida,30/09/2018 12:00:00 AM,3
Ramesh,21/08/2018 12:00:00 AM,2
Name1,20/09/2018 12:00:00 AM,0
Name2,21/08/2018 12:00:00 AM,0
Name3,20/07/2018 12:00:00 AM,5
Babu,11/09/2018 12:00:00 AM,3
Modi,07/10/2018 12:00:00 AM,9
];

Capture.JPG

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.