topic Set Analysis in QlikView

Set Analysis

Fri, 22 May 2009 22:55:29 GMT

I have this expression which works fine for this years data. But I am trying to get the same calculation for last year can someone help me with it... Thanks in Advance

(

Sum(if ([Adjustment Type]='Other Adjustments',[Adjustment Amount],0

))

(

Sum(if ([Adjustment Type CDE]='PLNC'and [Vendor ID]<>800790009,[Adjustment Amount],0

))

Sum

(if (([Flg - PLNC Account]=1 and [Adjustment Type CDE]='S') and ([Vendor ID]<>800790009 ), [Adjustment Amount],0

))

Sum

(if (([Flg - PLNC Account]=1 and [Adjustment Type CDE]='PLNC') and ([Vendor ID]<>800790009 ), [Adjustment Amount],0

))))

(

Sum(if

(

[Adjustment Type CDE]

='S'

[Adjustment Type CDE]

='PV' or

[Adjustment Type CDE]

='RTN' or

[Adjustment Type CDE]

='PLNC'

[Adjustment Amount],0

)))

Set Analysis

Fri, 22 May 2009 23:00:22 GMT

Can attach your qvw with the question area/object highlighted? Thanks.

Set Analysis

Fri, 22 May 2009 23:06:26 GMT

I am sorry i didnt get that, I am really new to this system what do you want me to do?

Set Analysis

Sat, 23 May 2009 00:26:06 GMT

Please attach the QVW report file you are working on, that you need help with. It is called something like ******.qvw. You can attach it to a post by going to the Options section, on the top.