topic Re: Need help on converting sql syntax to qlik in QlikView

Need help on converting sql syntax to qlik

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

Hi Team,

case when PLN33 ='GEC'

then 'GEC - ' || DEPARTMENT else PLN33 end DEPARTMENT.

please any one help on this to change in to qlik syntax

Thanks,

Chinnu.

kenphamvn — Mon, 28 Aug 2017 10:12:08 GMT

you can using if statement or Pick/match function

Please refer

chinnu123 — Mon, 28 Aug 2017 11:10:32 GMT

Hi An Pham,

Thanks for your quick reply. I tried by using pick and if conditions but its not worked.

Thanks,

Chinnu

sergio0592 — Mon, 28 Aug 2017 11:17:32 GMT

Try with:

LOAD

If(PLN33 ='GEC','GEC - ' & DEPARTMENT,PLN33) ,

xxx,

...

chinnu123 — Mon, 28 Aug 2017 11:29:06 GMT

Thanks Jean For your time its working fine now.

sergio0592 — Mon, 28 Aug 2017 11:48:32 GMT

So, if you want to use Pick/Match you try with:

LOAD

pick(match(PLN33,'GEC')+1, PLN33, 'GEC - ' & DEPARTMENT),

xxx,