5 Replies Latest reply: Jun 22, 2015 3:04 AM by lenin R RSS

    100% Stacked bar chart in Qlik Sense

    Tang man

      Dear Community

       

      I wonder how can I build a 100% Stacked bar chart in Qlik Sense. My case is the follows.

      The result I want is to measure the number of occurrences of Type in Month.

       

      However, I don't know how to build it in Qlik sense.As I already set:

      Dimensions:

      1. Month (Date)

      2. Type

       

      Style = stacked

      Show in percent

      Static max 1

       

      How can I set the expression in Measures?

       

      Thank you very much. Please give me a helping hand.

        • Re: 100% Stacked bar chart in Qlik Sense
          Jonathan Poole

          Here is a sample. 

           

          My measure is sum(Sales).

           

          But to get a relative contribution i changed it to:   sum(Sales) / sum( TOTAL <Year>  Sales)  

           

          The denominator calculates the total Yearly value. And with Year as the bars, it will do a share of 100% calculation

           

          Untitled.png

            • Re: 100% Stacked bar chart in Qlik Sense
              Tang man

              Jonathan Poole Thank you very much for help. But I still can't build the table.

               

              However, in my case, my original data format in date is in a whole date (1/1/2015) not only a month (1).

              Dimensions:

              1. Month (Date)

              2. Type

               

              If I type

              Measure: count(Type) / count( TOTAL <Date>  Type)

              The result is not I want to be as it count the Type per month over the Total type of all records.


              If I type

              Measure: count(Type) / count( TOTAL <Month (Date)>  Type)

              It can't show any thing because it is wrong expression.


              What I want is Type per month over the Total Types within a month. How can I do the data transforming from Date to Month and available to use in the Measure in Qlik Sense?


              Thank you very much for answering.


            • Re: 100% Stacked bar chart in Qlik Sense
              lenin R

              How we can show the Split-up of Contribution Values inside the chart