5 Replies Latest reply: Sep 21, 2016 12:18 PM by Vinol Dsouza RSS

    100% stacked with alternate dimensions in Qlik Sense

      Hello everyone,


      I am trying to create a stacked bar chart with 100% value for each bar. I need to create a 100% stack even when the dimension changes from day to week to month, is this possible ? Any workaround is appreciated


      chooco_co kha mto isaaclin


      My dimensions are:

      Date (browse_date)

      Source (divided into paid and organic)


      And i used the following function to determine share percentage

      Sum(sessions)/Sum(TOTAL <browse_date> sessions)


      When it is set date-wise there is no problem with the bar chart, however when i change it into =monthname(browse_date) each bar corresponds to the percentage of the WHOLE year. 100percent stack .PNG


      Is there a way to make this work when changed into month-wise so it represents 100% of each month?


      I have attached the qvf file for a better understanding of the issue.