problem with 'Dual If'

[#1]

Hi

I am relatively new to Qlikview and have encountered a problem with an expression that contains a dual if statement, the expression is as follows:

sum(if (Year = vYear1,

  (if Exempt = 0,(Price - Tax - Service - 0),(Price - Tax - Service - Nett)),)

  )

based on the values of the Exempt field I either need to subtract the Nett or not.

[arulsettu · Accepted solution]

try like this

sum(if (Year = vYear1,

  if(Exempt = 0,(Price - Tax - Service - 0),(Price - Tax - Service - Nett)),)

  )

[#3]

Thank you!

[anbu1984]

sum(if (Year = vYear1,(Price - Tax - Service - If(Exempt=0,0,Nett)) )  )