Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thanhphongle
Creator II
Creator II

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
MK_QSL
MVP
MVP

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

View solution in original post

3 Replies
MK_QSL
MVP
MVP

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
Creator II
Creator II
Author

thank you

MK_QSL
MVP
MVP

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