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"
Retrieving data ...