18 Replies Latest reply: Aug 15, 2017 1:28 PM by Sujit Gouda RSS

    12M Rolling Chart

    Sujit Gouda

      Can you please help with the below expression

       

      I have created a bar chart to show data for 12 Month Rolling Period.

       

      Without any filtering, I see the data rolled for 12 Months correctly.

       

      But once I start, selecting the values in the Filter the Dashboard doesn't filter correctly to show 12month it selects from the month selected and forward. please help.

       

      Max(Report Date) = '7/31/2017'

       

      sum(

      {<

      [Report Year]=,

      [Report Month]=,

      [Report Date]={'>=$(=MonthStart(Max([Report Date]),-11))<=$(Date(Max([Report Date])))'}

      >}

      NetFlows)/1000000

       

      Without Selection:

      Rolling_12M_Qlik.png

       

      With selection on May 17

      Rolling_12M_Qlik_Error.png