topic Between Value in QlikView

Between Value

Tue, 11 Oct 2011 09:11:18 GMT

Hi,

It's should be an easy task I can solve with some if but I'm sure there should be a function.

If I want just to compare some value with my range and know if my value it's between or not the range I've

(eg min 200 and max 400 and my value is 320. In this case my fucntion should reply YES)

Does it exist ? Without the requirement to use resident table with intervalmatch.

Thanks

swuehl — Tue, 11 Oct 2011 09:31:58 GMT

I think it is only one if-function you need:

if( Value >= Min and Value <= Max, 'Yes', 'No') as InRange

(for use in script, use > resp < if your Value needs to be inbetween min and max exclusive these limits)

=if( Value >= Min and Value <= Max, 'Yes', 'No')

as expression.

Hope this helps,

Stefan