4 Replies Latest reply: Aug 31, 2018 7:59 AM by Sumeet Naik RSS

    How to create bar graph for "Rolling 12 months data excluding current ongoing month?

    Sumeet Naik

      Hello All,

       

      I am trying to create bar graph for "Rolling 12 months data excluding current ongoing month" and i have an expression set in master item but the output includes data from current month also. Below is the expression -

       

      COUNT(

      {

      1<[Created On Dt]={'>=$(=Monthstart(Addmonths(Max([Created On Dt]),-12)))<=$(=Max([Created On Dt]))'}>

      }

      IF(ISNULL(Id),0,1)

      )

       

       

      P.S. - I am completely new in this Qlik sense world! Any help with simple explanation will be appreciated.