4 Replies Latest reply: Apr 14, 2017 12:50 AM by Rahul Pawar RSS

    Max date in data

    Monica Labrador

      Hi,

      New to qlik sense, I have a dataset like the one below, where I need to summarize last month's sales.

       

      My result should be Sales for last month-> March 2016 = $78

       

      How can I do this in a set analysis?

       

      I have tried sum ({< [Month Year] = {'$(=Max(Date))'} >}  [Sales])  but no luck.

       

        

      CustomerMonth YearSales
      A1/1/16$10
      B1/1/16$11
      C1/1/16$12
      D1/1/16$13
      A2/1/16$14
      B2/1/16$15
      C2/1/16$16
      D2/1/16$17
      A3/1/16$18
      B3/1/16$19
      C3/1/16$20
      D3/1/16$21