How to show positiv and negative value in the same chart?

[#1]

Hi all,

I'm a brand new user of Qlikview, and i must admit that day after day i'm enjoying this soft more and more...

However, i'm in front of an issue and i definitelly don't find any solution.

In a table, i have spanish areas like Madrid or Barcelona, and in front of them, i have some positive and negative values.

For instance, Madrid can be repeated several times like that:

Madrid / 1

Madrid / 6

Madrid / -4

Madrid / 3

with the area and the number in sparated columns...

My issue is that i'd like to create a chart that sum the positive values on one hand and negative values on the other; the goal of that is to have a chart that shows the sum of positive value above 0 and the sum of negative values under 0...., on the same bar.

Actually, don't know if that's possible, but i'm asking

Thanks

[SunilChauhan]

make two expression in any chart

1.sum(if(column>0,culumn)

2.sum(if(column<0,culumn)

[#3]

city	value
Madrid	4
Madrid	5
Madrid	-6
Madrid	-4
Madrid	8
Barcelona	5
Barcelona	-6
Barcelona	-2
Barcelona	8
Barcelona	3

if you ve values like above, the maximum possiblity is attached.

[#4]

thanks a lot i'll have a look at it and tell you

thx

[#5 · Accepted solution]

Works perfect thanks a lot