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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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?



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