Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there any use of case statement in qlikview?
yes, search for switch case in the help file (or on the forums)
thanks
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"
ELSE "GENPOLICY"."POL_CANCEL_CDE"
END As "Cancel Code"