topic 100% stacked bar chart in QlikView

100% stacked bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I'm working on a 100% stacked bar chart.

I found some topics in the community regarding this question:

100% Stacked bar chart in Qlik Sense | Qlik Community

100% Stacked Bar Graph‌

Keywords : TOTAL, ALL & DISTINCT

Regretfully, it doesn't seem to be working in my specific situation.

So, I already created a measure with this expression:

Count([Order Reference Deliveries])/Count(Total <Month> [Order Reference Deliveries])

And I created a stacked bar chart with these dimensions/measures:

This is the result:

So.... what am I doing wrong?

Re: 100% stacked bar chart

krishnacbe — Thu, 19 Oct 2017 19:05:18 GMT

Hi,

Have you set the Measures Number formatting to %?

Re: 100% stacked bar chart

Anonymous — Fri, 20 Oct 2017 05:54:52 GMT

Not in the example above. But I did try that, didn't help.

The problem is (in my opinion) that Qlik Sense won't use the <Month> 'filter' in the expression (after Total)

It seems that it divides by the total amount in stead of the amount of the specific month.

Re: 100% stacked bar chart

Anonymous — Fri, 20 Oct 2017 08:59:29 GMT

I discovered the problem.

In my chart I used an old master dimension called 'Month', while in the meantime I had also created a master calender with the field 'Month'.

In the chart I replaced the master measure 'with the field, and now it's working:

Knowing that, brings me to a new problem.

In reality I would like to use my master measure 'Period' instead of the Month field....because I want the combination month/year...

My master measure periode has this expression: Monthname(Date)

When I replace the dimension Month by the master dimension Period, I'm back where I started:

... and it's not possible to refer to a master dimension in a expression. So what do I do now? Do I have to get rid of my master dimension 'Period' and re-create it somehow in the master calendar?

Re: 100% stacked bar chart

Mark_Little — Fri, 20 Oct 2017 09:10:08 GMT

Hi Gert,

Having a quick look I would assume that your data spans a number of years.

I would try the same thing, but total by the Month Year field, if you have one?

Mark

Re: 100% stacked bar chart

sunny_talwar — Fri, 20 Oct 2017 11:35:44 GMT

I think you will need to calculate MonthYear field in the script... Master dimension isn't going to work... what is the issue with doing MonthName(Date) as MonthYear in script?

Re: 100% stacked bar chart

ashishpalkar — Wed, 20 Dec 2017 22:52:43 GMT

Hi There

I am have similar issue where

I am using 2 dimensions and trying to create % stack graph.

I am using following expression

Please find attached screenshot.

Sum(Aggr(Max(PurchaseQuantity),LoanXID))/Sum(total Aggr(Max(PurchaseQuantity),LoanXID))

any suggestions?

Re: 100% stacked bar chart

sunny_talwar — Wed, 20 Dec 2017 22:56:34 GMT

May be this

Sum(Aggr(Max(PurchaseQuantity), LoanXID))/Sum(TOTAL <Arranger> Aggr(Max(PurchaseQuantity), LoanXID))

Re: 100% stacked bar chart

ashishpalkar — Thu, 21 Dec 2017 14:26:53 GMT

Thanks Sunny, it worked perfectly.

Re: 100% stacked bar chart

Anonymous — Wed, 03 Jan 2018 10:20:08 GMT

Let's give you guys an update.

I created a MonthYear field in the script, and now the problem is partly solved:

The measure will now only show the 24 rolling months (i'm using a flag in my master calendar for this)

Expression: Count({$<IsR24M={1}>}[Order Reference Deliveries])/Count({$<IsR24M={1}>} total <MonthnameYear>[Order Reference Deliveries])

Looks great? Indeed, but here's the new problem.

I really want to use custom colors (that's the reason why I was using the method above)

This is my color expression:

IF(DP_Category = 'Too late', RGB(131,208,245), IF(DP_Category = 'On time', RGB(0,108,183)))

When I add my color expression now, this is the result:

On the Y-axis, Qlik Sense is showing more than 24 months.

I did find some similar problems, but no solution:

Qlik Sense color expression issue | Qlik Community

Qlik Sense Color by Expression bug

How to resolve this?

Greetings

Gert

Re: 100% stacked bar chart

sunny_talwar — Wed, 03 Jan 2018 12:11:01 GMT

Try this as your color expression

If(Only({$<IsR24M={1}>} DP_Category) = 'Too late', RGB(131,208,245),

If(Only({$<IsR24M={1}>} DP_Category) = 'On time', RGB(0,108,183)))

Re: 100% stacked bar chart

Anonymous — Wed, 03 Jan 2018 13:25:56 GMT

Works like a charm, thank you very much!

Re: 100% stacked bar chart

Vito — Fri, 06 Mar 2020 17:49:18 GMT

Hi, I have the same issue but I am not sure how to correct. The 100% stacked chart is accumulating the months instead of showing individually.

How can I correct this

Re: 100% stacked bar chart

mahendrankr — Wed, 22 Apr 2020 18:07:54 GMT

hi sunny, i have similar issue.

From the below data table, im trying to make a 100% stacked chart. But the condition is it would be only for the year 2020.

Year	Month	Produ	Units
2019	Jan	A	5
2019	Feb	A	10
2019	Mar	A	20
2019	Jan	B	5
2019	Feb	B	14
2019	Mar	B	13
2019	Jan	C	7
2019	Feb	C	8
2019	Mar	C	9
2020	Jan	A	5
2020	Feb	A	10
2020	Mar	A	20
2020	Jan	B	5
2020	Feb	B	14
2020	Mar	B	13
2020	Jan	C	7
2020	Feb	C	8
2020	Mar	C	9

Im using the below expression:

(Sum([Sellout Qty])/Sum( Total <Month> [Sellout Qty]))

but am not able to condition it to the year 2020 only .

Pl help.