topic Re: Stacked Bar Chart in QlikView

Stacked Bar Chart

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

I want to have my chart like this:

Re: Stacked Bar Chart

adityaakshaya — Tue, 17 Jul 2018 19:16:36 GMT

Hi Peter,

Please find attached demo file for your reference.

Regards,

Akshaya

Re: Stacked Bar Chart

BalaBhaskar_Qlik — Wed, 18 Jul 2018 15:29:48 GMT

Try to change your expressions like:

You would do this with the TOTAL function, so if your expression is sum(Value) percentage would be:

sum(Value) / sum(TOTAL Value)

Where the TOTAL causes the divisor to calculate across all dimensions. If you have two dimensions in your chart (say in a Pivot) you can do the total across a second dimension:

sum(Value) / sum(TOTAL <Dimension> Value)

If you want to ignore selections on a certain field (so you always look at the total, not the total of selected items) you can use set analysis to ignore some selections in the total:

sum(Value) / sum({<Dimension=}>} TOTAL Value).

After this, change the Presentation options of Bar chart.

Re: Stacked Bar Chart

Anonymous — Wed, 18 Jul 2018 17:00:09 GMT

Thanks for your response.

I wanted something like this:

Re: Stacked Bar Chart

Anonymous — Wed, 18 Jul 2018 17:01:06 GMT

I uploaded it, in case someone else needs it.