topic Comparing Two Values to get the difference in QlikView

Comparing Two Values to get the difference

Mon, 11 Apr 2011 21:31:53 GMT

Hello,

I'm trying to compare two values in an expression and get the difference but I don't want a negative number. Is there anyway to formulate this WITHOUT an If statement>???

Example: I'm comparing The Book quantitiy of several items and the counted quantity. I want a new field that is the difference between the two and is always a positive number.

Comparing Two Values to get the difference

prieper — Mon, 11 Apr 2011 21:34:37 GMT

Give it a try with (A>B)*(A-B)
should end with 0 for negative differences.

HTH
Peter

Comparing Two Values to get the difference

Mon, 11 Apr 2011 21:44:33 GMT

Hello, I apologize for not being clear in my original post. I am looking for the variation between the two numbers, I do not want any values to be changed to zeros.

For example if the book quantity is 20 and the counted quantity is 30 I want it to produce the number 10

and if the book quantity is 20 and the counted quantity is 10 I want it to produce the number 10 also.

I was wondering if this is possible without an If statement? Thank you for your help.

Comparing Two Values to get the difference

Mon, 11 Apr 2011 22:41:59 GMT

You can use the function fabs( ) to get the absolute value, always positive.