4 Replies Latest reply: Mar 28, 2012 10:30 AM by Robert Valanzola RSS

    If Then Else with Sum Not Working

    Robert Valanzola

      Help, I am new to Qlikview and ready to go crazy.


      I have SQL and .NET experience and I am trying to do something that is so easy using those tools.


      In my QVW document, I have a chart, and within that chart I am trying to build an Expression.


      Here is the simple English:


      If the rProcedure Class Code field has a value of 'MR', then sum the numeric value of the rUnits field.


      Here is the QV syntax.


      If([rProcedure Class Code])='MR', Sum(rUnits))


      I get an Expression OK, but the If Then Else seems to have no effect on my chart.


      If I do not do the If Then Else, and simply sum rUnits, I get desired results.


      I also tried doing an UPPER and TRIM, in case there were any extra characters or mixed case characters, with no success. And I checked the table for the existance of 'MR' and it was there. Seems so simple. What am I doing wrong?