topic Re: How to find difference value between two object in QlikView

How to find difference value between two object

Wed, 30 Jan 2013 06:35:41 GMT

I have problem about Summary value from two object.

I want value from column QTY in Object A plus with Column QTY in Object B by use expression in object C.

Can Qlikview reference value from other object?

khadeer — Wed, 30 Jan 2013 06:44:44 GMT

Check that file

Wed, 30 Jan 2013 06:46:51 GMT

take a pivot chart

dimension-- your unique field

expression-- add A

add B

add A-B

er_mohit — Wed, 30 Jan 2013 06:46:57 GMT

if i understand your problem then try this

using column function in pivot table

if you have one column for object A QTY and another column for OBJECT B QTY.

if one column for object A QTY having your 2nd expression and object B QTY is 3rd expression then

use expression column(2)-column(3)