Discussion board where members can get started with QlikView.
Is there any use of case statement in qlikview?
yes, search for switch case in the help file (or on the forums)
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.
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"
END As "Cancel Code"