topic Re: Expression using set analysis in QlikView

Expression using set analysis

Wed, 16 Oct 2013 14:22:43 GMT

Hi,

I have two columns from two different tables.

Employee	Payment
ID	PaymentID

I need to get TotalAmount as when PaymentID= ID so I write set anaysis like below

Sum({<PaymentID={ID}>}TotalAmount)

and TotalAmount values are in Payment table.

but when I am reloading it's shwoing £0 for all rows.

Could any one help me is there any error in set analysis expression

CELAMBARASAN — Wed, 16 Oct 2013 14:28:18 GMT

Hi,

Sum({<PaymentID={"=PaymentID=ID"}>}TotalAmount)

Sum({<UniqueID={"=PaymentID=ID"}>}TotalAmount)

Wed, 16 Oct 2013 14:53:20 GMT

Thanks and it's working