Select case in qlik sense

[Anonymous]

hi,

i am using Qlik sense desktop and i am wondering if there is  Select Case Statement in qlik sense ,

i found option that could do the same as previous function

load*,

PICK(MATCH(1 , "gap the current age" = 1, "gap the current age" = 2, 1), 'ayear', '2 years', 'more than 3 years');

but when i use it in my script i it works but it does not appear in app view as field

[Chanty4u]

did you given any name?

load*,

PICK(MATCH(1 , "gap the current age" = 1, "gap the current age" = 2, 1), 'ayear', '2 years', 'more than 3 years')  as AgeGap;

[Anonymous]

yes and still not showing in my app

[prma7799]

Please share some sample app. or any script screen shot.

[datanibbler]

Are you actually loading it from anywhere (is there a FROM or RESIDENT part)?

I don't know about QlikSense, I have no experience there, maybe that isn't necessary anymore? In QlikView it is ...

[Anonymous]

@Chanty 4u

@P M

@Friedrich Hofmann

Resident was missing  and it worked

thanks a lot  .

[Chanty4u]

good please close this thread