topic Re: Stacked Bar issue in QlikView

Stacked Bar issue

alec1982 — Fri, 14 Dec 2012 14:50:26 GMT

Hi Guys,

I have a stacked bar with two expressions in it.

since it is a stacked bar the values that show next on the bars are the Sum of the Stacked bars.

I have noticed that when there is a negative value at one of the stacked bars and positive value within the same stacked bars it doesn't give me the total of both meaning it shows two values the negative by itself and the positive by itself. and the negative value is showing at the other side of the bar.

How can I make the chart to show me the sum of both the negative and positive value as one value?

Sample on a single bar I have two stacked values -50 and the second stacked value is 120 .. so I need the value on the value on data Point to show = 70

Thxs,

Alec

Re: Stacked Bar issue

Fri, 14 Dec 2012 15:34:53 GMT

Are you saying that 1 expressions returns a pos number and the other expression returns a neg number? Couldn't you just put together a formula that is the sum of both expressions?

Re: Stacked Bar issue

alec1982 — Fri, 14 Dec 2012 15:49:21 GMT

the reason of having a stacked bar is when you move your mouce above any of the stacked bars you will get the value for it and the value of the data point should show both of them summed.

Thxs,

Re: Stacked Bar issue

bdunphy — Fri, 11 Jan 2013 17:19:30 GMT

I have this same problem ? Any ideas ?

Re: Stacked Bar issue

alec1982 — Fri, 11 Jan 2013 17:32:46 GMT

I really couldn't find a slotion so i I am not using the stacked bar anymore!

Re: Stacked Bar issue

karolina_ — Thu, 12 Sep 2013 07:50:57 GMT

Has anyone came up with solution for this? I keep trying to have sum of negative and positive...

Re: Stacked Bar issue

michael_maeuser — Thu, 12 Sep 2013 07:57:12 GMT

have you tried to calculate in the script so that you already have the aggregated value?

s.th. lik

load

dimension a

dimension b

sum(value)

residen table

group by dimension a, dimension b;

maybe then it shows only one value, but not sure

Re: Stacked Bar issue

karolina_ — Thu, 12 Sep 2013 08:09:59 GMT

I guess it's reply to my post.

[Edited] user can choose date so values out of the date range are not counted, but there are 5 options only so script might be good idea or 4 text boxes with rules and no options in chart to show values choosen