topic Re: problem with 'Dual If' in QlikView

problem with 'Dual If'

Tue, 30 Dec 2014 10:35:56 GMT

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 — Tue, 30 Dec 2014 10:45:34 GMT

try like this

sum(if (Year = vYear1,

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

)

Tue, 30 Dec 2014 10:51:44 GMT

Thank you!

anbu1984 — Tue, 30 Dec 2014 11:04:40 GMT

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