topic Expression help in QlikView

Expression help

Sun, 16 Dec 2012 07:19:47 GMT

Need to calculate value of subject 2 where class is B and subject 2 is greater then Subject A

Sun, 16 Dec 2012 07:31:21 GMT

Hi,

Try this expression " Sum({<Class={'B'}>} IF(Subject2>Subject1,Subject2)) ". Hope this will help.

Thanks,

Srini.

Sun, 16 Dec 2012 07:48:02 GMT

what's wrong with dis expression:

Sum(({<Status={'In Progress'}>}if(Sum([Act Value])>(Sum([Est Value])*0.9),Sum([Act Value])))

Sun, 16 Dec 2012 08:12:45 GMT

There were some syntax and logical error.

This is same as what i have suggested earlier. Just replace class with status, Subject 2 as Actuals and Subject1 as Est Value.

Sum({<Class={'B'}>} if(Subject2 >((Subject1)*0.9) ,Subject2))