topic CASE statement in qlikview in QlikView

CASE statement in qlikview

Tue, 23 Oct 2012 10:53:57 GMT

Hi,

Is there any use of case statement in qlikview?

Gysbert_Wassenaar — Tue, 23 Oct 2012 10:54:56 GMT

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

Tue, 23 Oct 2012 12:04:33 GMT

thanks

johnw — Tue, 23 Oct 2012 19:30:53 GMT

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.

Wed, 24 Oct 2012 07:15:37 GMT

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"