topic Set Analysis Error in QlikView

Set Analysis Error

Tue, 08 Nov 2011 11:21:13 GMT

Hi All

Getting error in expression.

Job Number and Sales Order Number has 1:1 relation and same no. For ex: If Job No = 1234 then Sales Order No = 1234

I want to link data so that I can get Invoice Amount details at Job No level.

Dimension = Job Number

I tried below expression but this gives error:

sum({<[Sales Order Num]={[Job Number]}>}[Invoice Amount])

Can someone help pl?

Anonymous — Tue, 08 Nov 2011 11:26:09 GMT

this should work:

sum({<[Sales Order Num]=P([Job Number])>} [Invoice Amount])

Thu, 10 Nov 2011 11:55:07 GMT

I tried above expression but its not working.

Any alternative?

SunilChauhan — Thu, 10 Nov 2011 12:34:35 GMT

use this

sum({<[Sales Order Num]={$(=[Job Number])}>}[Invoice Amount])

hope this help