Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split up an expression

Guys,

I have the following expression:

" =if(Age>=vExp_Age_Dwn and Length>=vExp_Len_Dwn ,if(Age<=vExp_Age_Up and Length<=vExp_Len_Up ,Name))


It works fine but as I want to include more components I would like to make it a little less messy. Any advice on best practises on how to cut up expressions?



3 Replies
sunny_talwar

You might be able to use Set analysis to make it simpler

Anonymous
Not applicable
Author

you can do like this:

=if((Age>=vExp_Age_Dwn and Age<=vExp_Age_Up) and (Length>=vExp_Len_Dwn and Length<=vExp_Len_Up),Name))

Anonymous
Not applicable
Author

remove 1 bracket after Name Field