topic Re: percentages on stacked chart in QlikView

percentages on stacked chart

markgraham123 — Thu, 14 Apr 2016 18:08:24 GMT

Hi ,

i have a stacked bar chart, where i want to display percentages insread of values on the data points.

Total bar value is 100% and every color represents its contribution.

PLease find the attached picture.

Re: percentages on stacked chart

sunny_talwar — Thu, 14 Apr 2016 18:15:57 GMT

Assuming this is what your current expression is -? Sum(Sales), try changing it to this:

Sum(Sales)/Sum(TOTAL <FirstDimensionHere> Sales)

Re: percentages on stacked chart

alexpanjhc — Thu, 14 Apr 2016 18:21:39 GMT

Did you try to check the relative in the expression?

Re: percentages on stacked chart

sunny_talwar — Thu, 14 Apr 2016 18:22:49 GMT

Relative with two dimensions is probably going to calculate the percentage based on the total which probably won't work for Mark

Re: percentages on stacked chart

alexpanjhc — Thu, 14 Apr 2016 18:42:02 GMT

I may not understand what exactly you mean, however, I just tested out a simple example with 2 dimensions and it is based out the total of first dimension when checking relative.(which i think it is your set analysis means)

Re: percentages on stacked chart

sunny_talwar — Thu, 14 Apr 2016 18:51:12 GMT

See the difference between the two charts in the image below

Top image is using Relative and the bottom one uses this expression -> =Sum(Value)/Sum(TOTAL <Dim1> Value)

Script used:

Table:

LOAD * Inline [

Dim1, Dim2, Value

A, C, 10

A, D, 20

B, C, 15

B, D, 12

];

Re: percentages on stacked chart

markgraham123 — Thu, 14 Apr 2016 19:39:01 GMT

Sunny,

Really Thanq verymuch for your time and patience brother.

In my application, the stacked chart is comprised of 2 expressions.

I think that's the reason.

Let me share the application please.

Re: percentages on stacked chart

sunny_talwar — Thu, 14 Apr 2016 19:42:39 GMT

For two expression you can do this:

Expression1:

Expression1/RangeSum(Expression1, Expression2)

Expression2:

Expression2/RangeSum(Expression1, Expression2)

Replace Expression1 and Expression2 with your existing Expressions in your chart.

Re: percentages on stacked chart

markgraham123 — Thu, 14 Apr 2016 19:50:04 GMT

Thanq Sunny

Re: percentages on stacked chart

sunny_talwar — Thu, 14 Apr 2016 19:51:19 GMT

No problem at all Mark

Re: percentages on stacked chart

alexpanjhc — Thu, 14 Apr 2016 20:18:20 GMT

Ah... i did not understand what the OP wants. Thanks for the clarification.