Sum If with SET analysis

Anonymous — Mon, 18 May 2015 07:47:01 GMT

I'm building an OPEX report and for certain G/L Accounts (eg "913990") do I only want to include values were WBS number = "#" but for everything else I want it all

The example below works but as you probably see does not give me the correct sum... However I'm stuck when I try to do a "Sum(if(XXX,YYY))" formula so hope someone see how this can be done when there is a need of SET analysis in the expression

Example:

if(

[Account Number - Level 06 - [80ACCOUNT]]]='913990',

Sum({$< [WBS Element - WBS Element Level 01 - [20PS_PRJTYPE]]]= {'#'},

[Account Number - Level 04 (Text)]={'Other Opex', 'Total personnel expenses'} ,

[Version - Version Level 01 (Text)]={'*actual*'}>}Amount),

Sum({$<

[Account Number - Level 04 (Text)]={'Other Opex', 'Total personnel expenses'} ,

[Version - Version Level 01 (Text)]={'*actual*'} >}Amount))

//Kim

topic Sum If with SET analysis in QlikView

Sum If with SET analysis