Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?



Labels (1)
3 Replies
sunny_talwar
MVP
MVP

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