Max month sales of each Year?

[vidyasagar159]

Hi,

I am a simple requirement. I want to show the max month sales of each year of my products. Unfortunately, I am not able to find the logic. Please find some sample data below. I am doing this in Qlik Sense. Thanks in advance.

Product	SalesDate	SalesAmount
Apple	Jan-30-2017	$100
Apple	Feb-28-2017	$50
Apple	March-30-2017	$200
Apple	Jan-30-2018	$200
Apple	Feb-28-2018	$100
Apple	March-30-2018	$300
Apple	April-30-2018	$400

Now what I want to show is MAX month of every year in my Table or in my Barchart is.

Product	SalesDate	SalesAmount
Apple	March-30-2017	$200
Apple	April-30-2018	$400

Thanks,

-Vidya

[vidyasagar159]

Thanks for your help. I never thought that this can be done by using Rank function. I really appreciate your help.