4 Replies Latest reply: Feb 12, 2015 2:47 PM by Tang man 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
          Nils Morris

          Hi

          Use a Stacked Bar Chart with two dimensions (Month,Type)

          and the following Measure

          Count(Type) / Count(total <Month> Type)

          With Custom Number formatting (#,##0%)

           

           

           

          You should end up with something like this.

          Capture.PNG

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

              Nils Morris Thank you very much for help.

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

              Apart from changing the original data format in Excel from Date to Month, How can I do the data transforming from Date to Month and available to use in the Measure in Qlik Sense?

               

               

              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.



              Thank you very much for answering.