CASE statement in qlikview

[#1]

Hi,

Is there any use of case statement in qlikview?

[Gysbert_Wassenaar]

yes, search for switch case in the help file (or on the forums)

[#3]

thanks

[johnw]

Or if you mean for an expression:

pick(match(MyField,'Case 1','Case 2'),Result1,Result2)

Or with a default:

pick(1+match(MyField,'Case 1','Case 2'),Default,Result1,Result2)

A series of if() statements may be easier to read in an expression, though.

[#5]

Hi so using your syntax how would you convert this syntax below. I know how to use the if statements but want to compare with case as well

  CASE WHEN "GENPOLICY"."POL_CANCEL_CDE" IS NULL THEN "MDRCANCELREF"."MDRCANCELREF_KEY"

                  ELSE "GENPOLICY"."POL_CANCEL_CDE"

             END As "Cancel Code"