topic Re: Select case in qlik sense in QlikView

Select case in qlik sense

Anonymous — Thu, 06 Jul 2017 12:08:32 GMT

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 — Thu, 06 Jul 2017 12:10:55 GMT

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 — Thu, 06 Jul 2017 12:23:25 GMT

yes and still not showing in my app

prma7799 — Thu, 06 Jul 2017 12:26:12 GMT

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

datanibbler — Thu, 06 Jul 2017 12:26:39 GMT

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 — Thu, 06 Jul 2017 12:41:08 GMT

Resident was missing and it worked

thanks a lot .

Chanty4u — Thu, 06 Jul 2017 13:37:10 GMT

good please close this thread