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

    Qlik Sense Comparison to previous period Set analysis

    Matti Lepistö

      Hi,

       

      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?