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?

       

      Thanks,

       

      Bob