Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Select case in qlik sense

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

6 Replies
Chanty4u
MVP
MVP

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
Not applicable
Author

yes and still not showing in my app

prma7799
Master III
Master III

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

datanibbler
Champion
Champion

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
Not applicable
Author

@Chanty 4u

@P M

@Friedrich Hofmann

Resident was missing  and it worked

thanks a lot  .

Chanty4u
MVP
MVP

good please close this thread