topic Re: Compare 2 Values in QlikView

Compare 2 Values

Mon, 11 Jun 2012 17:42:28 GMT

Hi Guys,

i wonder if you can help me i have a straight table with two values i would like to add an expression on there that shows me the difference between the two values but im not sure how to do this

could someone please point me in the right direction

thanks in advance

Compare 2 Values

jonathandienst — Mon, 11 Jun 2012 18:34:24 GMT

If the two values are in columns 1 and 2 respectively, then you can use

=Column(1) - Column(2)

Note that column 1 is the first expression, and Column() refers to the expression values. You can't get the dimensions in the same way

Hope that helps

Jonathan

Re: Compare 2 Values

Tue, 12 Jun 2012 07:10:39 GMT

Thanks Jonathan thats great

Re: Compare 2 Values

Tue, 12 Jun 2012 14:47:48 GMT

Hi Jonathan,

do you happen to know how i can exclude anything with a difference of 0?

thanks in advance

Re: Compare 2 Values

jonathandienst — Wed, 13 Jun 2012 15:14:15 GMT

Just make sure all your expressions return null or 0 if column(1) = column(2).

I think you will need to use the actual expressions, rather than column().

Expression 1: If(<expr1> = <expr2>, 0, <expr1>)

Expression 2: If(<expr2> = <expr1>, 0, <expr2>)

Expression 3: Column(1) - Column(2)

Where <expr1> and <expr2> are the current expressions in columns 1 & 2.

Regards

Jonathan