topic If statement to evaluate in interval in QlikView

If statement to evaluate in interval

pduplessis — Fri, 27 Aug 2010 03:14:18 GMT

In a load script I was hoping there would be a quick way to determine whether a numeric value falls within a range.

Something like

if( 0> myfield <1, 'BetweenZeroOne', 'NotBetween') as myfield2

something like inDay() which "returns true if timestamp lies inside the part of day containing basetimestamp up until and including the exact millisecond of basetimestamp".

If statement to evaluate in interval

Fri, 27 Aug 2010 04:58:41 GMT

hi,

try out this.

load myfield,if( myfield>=0 and myfield<=1, 'BetweenZeroOne', 'NotBetween') as myfield2

thanks

If statement to evaluate in interval

Fri, 27 Aug 2010 05:00:20 GMT

hi,

try out this.

load myfield,if( myfield>0 and myfield<1, 'BetweenZeroOne', 'NotBetween') as myfield2

thanks