topic Re: comparing a value between a range in QlikView

comparing a value between a range

saimahasan — Fri, 19 Aug 2016 13:44:54 GMT

Hi all,

I am stuck with a problem. Tried to find the solution on community but couldnt get.

I have a variable wherein i have a value for eg 94.5.

Now i have two fields MinRange and MaxRange as follows:

i have another fields Score and X_VAL

I need to check the range wherein the value 94.5 lies and accordingly display its score.

Re: comparing a value between a range

hic — Fri, 19 Aug 2016 13:59:17 GMT

Take a look at intervalmatch. IntervalMatch

HIC

Re: comparing a value between a range

saimahasan — Fri, 19 Aug 2016 14:02:43 GMT

But the value i want to compare is stored in a variable. and that variable is calculated in frontend.

So how will i compare a variables value with 2 fields??

Re: comparing a value between a range

hic — Fri, 19 Aug 2016 14:16:02 GMT

Then you need to express it with functions. One way is to use a nested If()-function - one If() per range.

Alternatively, you can use the class()-function. Or you can combine the two:

If(Variable<85,'Below',

If(Variable>=100,'Above',

Class(Variable,3, 'var', 1)

))

HIC

Re: comparing a value between a range

rwunderlich — Fri, 19 Aug 2016 15:31:33 GMT

In the script, you can generate the "between" values in increments of .01 as a new field "Index". And then choose a Score from the table using a rounding of the variable like:

Only({<Index={$(=round($(vInput),.01))}>}Score)

See attached example.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: comparing a value between a range

Anonymous — Fri, 19 Aug 2016 16:01:01 GMT

Simple correction:

"While (MinRange + (Iterno()*.01))-.01 < MaxRange" -> This should be <=MaxRange in order to consider the border case for Max Ranges