10 Replies Latest reply: Jun 11, 2018 2:27 PM by vidya sagar malla RSS

    Max month sales of each Year?

    vidya sagar malla

      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.

       

      ProductSalesDateSalesAmount
      AppleJan-30-2017$100
      AppleFeb-28-2017$50
      AppleMarch-30-2017$200
      AppleJan-30-2018$200
      AppleFeb-28-2018$100
      AppleMarch-30-2018$300
      AppleApril-30-2018$400

       

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

       

      ProductSalesDateSalesAmount
      AppleMarch-30-2017$200
      AppleApril-30-2018$400

       

      Thanks,

      -Vidya