7 Replies Latest reply: Jan 20, 2018 10:14 PM by Sunny Talwar RSS

    Calculate previous month sales - Qlik Sense

    Balaji SJ

      Hello People

       

      To calculate previous month sales, I wrote the exp as mentioned below but i get null values when certain month in selected in filter pane. Please help me to solve this issue.

       

      =Sum({$<Month={"$(=Max(Month-1))"}>}sales)