Need help on converting sql syntax to qlik

[chinnu123]

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]

Hi

you can using if statement or Pick/match function

Please refer

Pick and Match example

[chinnu123]

Hi An Pham,

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

Thanks,

Chinnu

[sergio0592 · Accepted solution]

Try with:

LOAD

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

xxx,

...

[chinnu123]

Thanks Jean For your time its working fine now.

[sergio0592]

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

LOAD

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

xxx,