topic Re: case Statement in Qlikview in QlikView

case Statement in Qlikview

SK28 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I was wondering if anyone would be able to help me. I want to create the following Case statement in QlikView:

CASE

WHEN DISTRICT IN ('0317','0328','0030','0057','0122','6057','6130','6150','6317','6631') AND

YYYYMM <= '201602' THEN 'A'

WHEN DISTRICT IN ('0317','0328','0030','0057','0122','6057','6130','6150','6317','6631') AND

YYYYMM BETWEEN '201603' AND '201605' THEN 'B'

ELSE 'C' END AS STAGES,

Is this possible to do within QlikView?

Any help would be greatly appreciated.

thanks.

Re: case Statement in Qlikview

sergio0592 — Mon, 30 Jan 2017 13:11:16 GMT

Try

If(match(DISTRICT,'0317','0328','0030','0057','0122','6057','6130','6150','6317','6631')>0 and YYYYMM <= '201602','A',if(match(DISTRICT,'0317','0328','0030','0057','0122','6057','6130','6150','6317','6631')>0 and (

YYYYMM > '201603' AND YYYYMM <'201605'),'B','C'))

Re: case Statement in Qlikview

ramasaisaksoft — Mon, 30 Jan 2017 13:33:18 GMT

For Switch case also we need to follow if else conditions/Nested if only in Qlikview .