5 Replies Latest reply: Nov 24, 2017 12:36 AM by Chris Wong RSS

    Qlik Sense - Sum This Month vs Last Month same date

    Chris Wong

      Dear Community,

      How to sum this month vs last month same date?

       

      Records:

      Date(DD-MM-YYYY)  Value

      01-10-2017              5

      02-10-2017              50

      03-10-2017              17

      04-10-2017              30(Should exclude this record)

      01-11-2017              15

      02-11-2017              30

      03-11-2017              2

       

      Expected Result:

      Month Year    Value

      Oct' 17          32

      Nov' 17          47

       

      32 = 5+ 50 + 17

      47 = 15 + 30 + 2

       

      I tired the Expression:

      sum({<[Date] = {">=$(=MonthStart(AddMonths(Max([Date]),-1)))<= $(=MonthEnd(AddMonths(Max([Date]),0)))"}>}[Value])