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

# 100% Stacked bar chart in Qlik Sense

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

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

• ###### Re: 100% Stacked bar chart in Qlik Sense

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

You can load in a new field in your data model to store the months:

Date

from ...

to:

Date,

Month(Date) as Month

from ...

Then use the 'month' field as a dimension in your chart and in the TOTAL clause of the measure expression.

Does this make sense ?

• ###### Re: 100% Stacked bar chart in Qlik Sense

Jonathan PooleThank you very much. I am able to create the 100% stacked bar chart and the field form data load editor that I want in Qlik Sense. You are very smart and very nice for helping me. Much Thanks.

• ###### Re: 100% Stacked bar chart in Qlik Sense

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