Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

thanhphongle
Contributor

interval and if expression

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

1 Solution

Accepted Solutions
MVP
MVP

Re: interval and if expression

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

3 Replies
MVP
MVP

Re: interval and if expression

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
Contributor

Re: interval and if expression

thank you

MVP
MVP

Re: interval and if expression

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

Community Browser