topic Re: How to compare positive and negative values in QlikView

How to compare positive and negative values

don_qlikview — Tue, 10 Nov 2015 20:54:44 GMT

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:

In this case I want the result to be

How can I do this?

Thanks in advance

Don

swuehl — Tue, 10 Nov 2015 20:59:14 GMT

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 — Tue, 10 Nov 2015 21:06:04 GMT

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 — Tue, 10 Nov 2015 21:10:01 GMT

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

don_qlikview — Tue, 10 Nov 2015 22:23:45 GMT

Thanks Swuehl. This worked

Anonymous — Wed, 11 Nov 2015 04:40:02 GMT

Hi Sohail,

how did you solve it...

Thanks in advance