2 Replies Latest reply: Feb 3, 2018 1:29 PM by ruti t RSS

    Issue with conditional in sum function - Qlik Sense

    ruti t

      Hi Everyone,

       

      I try to create measure the sum field where date equal to select date minus one month.

       

      I try some option but nothing work , for example:

       

      Sum({$<[Snapshot Date]=,[Snapshot Date] = MonthEnd(AddMonths(Max([Snapshot Date]),-1))}>} Sales)

       

      Could you please advise?

       

      Thank you!!

       

      Ruti.