topic Re: 100% stacked column chart in Qlikview? in QlikView

100% stacked column chart in Qlikview?

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

I need to create a bar chart in Qlikview that displays information of 2 dimensions (period and segment) and 1 expression (value in%), that total 100% in the bars.

Sum (Value) / Sum (Total Value).

When I use the "Total" or "All", the chart considers the value of all periods, when in fact I should only consider the total per period. I have already tried to use the Aggr expression, but it gives miscalculation.

Aggr (Sum (Value) / Sum (Total Value), Period).

I believe that Set Analysis does not apply to this calculation, since it will always consider the total value (of all periods).

In another environment, this graph is native and is called "100% Stacked Column Chart", as shown below.

Is it possible to reproduce this graph in Qlikview?

Tks!!!

Re: 100% stacked column chart in Qlikview?

effinty2112 — Thu, 28 Sep 2017 16:07:42 GMT

Hi Karen,

Try

Sum (Value) / Sum (Total <Period> Value)

Good luck

Andrew

Re: 100% stacked column chart in Qlikview?

oscar_ortiz — Thu, 28 Sep 2017 16:08:20 GMT

You can try an expression like the following:

Sum (Value) / Sum (Total <Period> Value)

Change your chart properties under style select Stacked:

Your result should look something like this:

Good Luck

Oscar

Re: 100% stacked column chart in Qlikview?

Anonymous — Mon, 02 Oct 2017 20:21:07 GMT

Oscar,

Thank you for your answer.

I tried but doesn't work like your example. Bellow:

Re: 100% stacked column chart in Qlikview?

oscar_ortiz — Mon, 02 Oct 2017 20:25:44 GMT

Karen,

I believe you need to remove your "{}" curly brackets.

Try this:

Count( CPF_CNPJ ) / Count( TOTAL <Periodo_Movimentacao> CPF_CNPJ )

Good luck

Oscar

Re: 100% stacked column chart in Qlikview?

Anonymous — Mon, 02 Oct 2017 20:29:51 GMT

Thank you so much Oscar! It worked

Re: 100% stacked column chart in Qlikview?

Anonymous — Tue, 17 Oct 2017 13:25:01 GMT

Hi Oscar,

Again I need to make this rule, but now also using Set Analysis, and following the same rule, doesn't return 100%

For Example:

Count({$<Code={"10"}>}Id)/Count(Total <Month,Day> {$<Code={"10"}>}Id)

Re: 100% stacked column chart in Qlikview?

oscar_ortiz — Tue, 17 Oct 2017 14:19:35 GMT

Karen,

Could you possibly provide some sample data with an explanation of what you are trying to do?

In your image what do the values in the legend associate to?

For the expression that you have it looks like you are simply trying to look at the Code=10 by date. Do you have an actual date field in your data model? Rather than using the Month and Day. Or possibly change your expression to use whatever value you have in your legend rather than the date.

Good luck

Oscar