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.

      MTD:

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

       

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

      vMaxYear = max"Calendar Year")



      PMTD:

      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