topic Re: Range in QlikView

Range

pkpandey — Mon, 26 Jan 2026 16:26:21 GMT

How to get the minimum and maximum range of a value falling between e.g.

Say User input Value is 75 and we have a range like

0 to 50

52 to 70

71 to 80

81 to 100

I have to get the the range 71 and 80 because 75 falls between this range.

Anonymous — Wed, 06 Aug 2014 07:33:07 GMT

Try to use the Inline table and fetch the result

tresB — Wed, 06 Aug 2014 07:44:44 GMT

Look at class(). If the intervals are not equi-distant, you might have to use nested ifs.

MK_QSL — Wed, 06 Aug 2014 08:23:48 GMT

Consider that you have variable named VALUE

User can change the VALUE of this variable....

Use below expression Text Box or in Chart ....

=IF(VALUE >0 and VALUE <= 50, '0 to 50',

IF(VALUE > 50 and VALUE <=70, '51 to 70',

IF(VALUE > 70 and VALUE <= 80, '71 to 80',

IF(VALUE > 81, '81 to 100'))))