topic Re: Split up an expression in QlikView

Split up an expression

Thu, 03 Dec 2015 11:12:21 GMT

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?

Re: Split up an expression

sunny_talwar — Thu, 03 Dec 2015 11:54:04 GMT

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

Re: Split up an expression

Anonymous — Thu, 03 Dec 2015 12:02:46 GMT

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))

Re: Split up an expression

Anonymous — Thu, 03 Dec 2015 12:03:24 GMT

remove 1 bracket after Name Field