topic Re: interval and if expression in Qlik Learning Discussions

interval and if expression

thanhphongle — Mon, 23 Feb 2015 10:45:22 GMT

hi, i'd like to know if my expression is correct.

if parameter <1.5 give out extension

if paramter is in [1.5 ; 2[ give out 60

if parameter is in [2 ; 2.4[ give out 48

if parameter is > 2.4 give out 36

here is my solution. is expression correct?

if(parameter<10.5, 'extension',

if(parameter=1.5 or parameter<2.0, '60',

if(parameter=2.0 or parameter <2.4, '48','36')))

MK_QSL — Mon, 23 Feb 2015 10:58:44 GMT

If(parameter >=1.5 and parameter < 2.0, '60',

If(parameter >=2.0 and parameter < 2.4, '48',

If(parameter >=2.4 and parameter <10.5, 'extension','36')))

thanhphongle — Mon, 23 Feb 2015 11:23:30 GMT

thank you

MK_QSL — Mon, 23 Feb 2015 12:34:45 GMT

If this is working for you... Kindly close the thread by selecting appropriate answer so that others can also use it.