Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
alec1982
Valued Contributor II

Stacked Bar issue

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

7 Replies
Highlighted
Not applicable

Re: Stacked Bar issue

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?

EK

Highlighted
alec1982
Valued Contributor II

Re: Stacked Bar issue

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,

Highlighted
bdunphy
New Contributor III

Re: Stacked Bar issue

I have this same problem ? Any ideas ?

Highlighted
alec1982
Valued Contributor II

Re: Stacked Bar issue

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

Highlighted
karolina_
Contributor II

Re: Stacked Bar issue

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

Highlighted
michael_maeuser
Contributor III

Re: Stacked Bar issue

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

Highlighted
karolina_
Contributor II

Re: Stacked Bar issue

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