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

    100% stacked with alternate dimensions in Qlik Sense

    Vinol Dsouza

      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.