Load max date and hour

[sanjujeeboy]

Hi All,

I have a table like this

Country	Date	Hour	Sales
germany	11/7/2019	1	100
germany	11/7/2019	2	101
germany	11/7/2019	3	102
germany	11/7/2019	4	103
Italy	11/7/2019	1	103
Italy	11/7/2019	2	104
Italy	11/8/2019	3	105
Spain	11/7/2019	1	106
Spain	11/7/2019	2	107
Spain	11/8/2019	3	108

Requirement is i want to get max date max hour sales for each country. So the output should be:

Country	Date	Hour	Sales
germany	11/7/2019	4	103
Italy	11/8/2019	3	105
Spain	11/8/2019	3	108

How to write a set expression for this?

[Brett_Bleess]

Duplicate post, see https://community.qlik.com/t5/QlikView-App-Development/Load-max-date-and-hour/td-p/1644389 for live thread.

Regards,
Brett