14 Replies Latest reply: Apr 16, 2018 9:08 AM by Oktay Pamuk RSS

    Qlik Sense Comparison to previous period Set analysis

    Matti Lepistö



      I have hard time getting my bar chart working as I would like to. What I would like, is to have a previous period from my selections next to the bar of current selections.


      The formula i have now:


      Count({<[Document Timestamp.autoCalendar.InYTD]=,[Document Timestamp.autoCalendar.Month]=,

      [Document Timestamp.autoCalendar.Date]={">=$(vMinDateLastPeriod)<=$(vMaxDateLastPeriod)"}>}DISTINCT Key_SessionCounter)


      I have put my variables to their own KPI boxes and they work fine.


      Could someone explain why my formula is not working?