3 Replies Latest reply: Nov 26, 2015 11:50 PM by balraj ahlawat RSS

    MTD and PMTD in Qliksense

    abhay singh

      HI all,


      I am trying to do MTD and PMTD but MTD is working an dPMTD is not working.


      NUm(Count({<"Calendar Month Num"={'$(vMaxMonth)'}, "Calendar Year"= {'$(vMaxYear)'}, TaskStatusNum= {'1'}>}SurveyTaskId),'#,##0')


      variable :  vMaxMonth = max("Calendar Month Num")

      vMaxYear = max"Calendar Year")


      NUm(Count({<"Calendar Month Num"={'$(vPreviousMonth)'}, "Calendar Year"= {'$(vMaxYear)'}, TaskStatusNum= {'1'}>}SurveyTaskId),'#,##0')


      variable :  vPreviousMonth= max("Calendar Month Num")-1

      vMaxYear = max"Calendar Year")

      Pls correct if m wrong