How to compare positive and negative values

[don_qlikview]

Hello every one,

I am trying to find negative and positive values based on a transaction id and if they have equal and opposite signs, I want to cancel them out:

For example if I have a table like below:

Transaction ID	Amount
12345	100
12345	-100
12345	200
6789	300

In this case I want the result to be

Transaction ID	Amount
12345	0
12345	200
6789	300

How can I do this?

Thanks in advance

Don

[swuehl]

Shouldn't just a sum(Amount) be sufficient?

Or maybe a straight table chart with dimension

=Dual([Transaction ID], fabs(Amount) )

and as expression

=Sum(Amount)

[don_qlikview]

Doing a sum(Amount) will give me only two records

12345 200

6789   300

whereas i want three records as mentioned in my question.

Thanks!!!

[swuehl · Accepted solution]

Using the calculated dimension should work, you need to disable 'suppress zero values' in presentation tab of straight table chart properties.

[don_qlikview]

Thanks Swuehl. This worked

[Anonymous]

Hi Sohail,

  how did you solve it...

Thanks in advance