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!!