8 Replies Latest reply: Feb 8, 2017 1:11 AM by Kaushik Solanki RSS

    Set analysis in QlikSense - variable help

    Carl Blunck

      Hi everyone,

       

      I am transitioning a dashboard from QlikView to QlikSense and a set analysis expression that works perfectly fine in QlikView is not working at all in QlikSense.

       

      Here is the expression from QlikView:

       

      Count({<MonthYear ={">=$(=date(addmonths(date#('$(vYearMonth)','MMM-YYYY'),-11),'MMM-YYYY')) <=$(=date#('$(vYearMonth)','MMM-YYYY'))"}, Year=,Month=>} DISTINCT(ows_ID))

       

      Can someone please help in getting this to work in QlikSense?

       

      Data models between QlikView and QlikSense are exactly the same and the variable is declaring the correct value so I am stumped!!

       

      Thanks in advance

      Carl