Discussion Board for collaboration related to QlikView App Development.
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
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?
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.
have you tried to calculate in the script so that you already have the aggregated value?
group by dimension a, dimension b;
maybe then it shows only one value, but not sure
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