Interval in expression

[#1]

Hi everyone,

Does anyone know if I can in table expression to check whether some percentage value less then other in some field?

I have table with field Year,Minimal Realization % and Bonus Amount (LCY),(picture below). What I want is to check all values from field minimal realization and gave him bonus amount if calculated value is less than values in minimal realization.

If my calculated vlaue is 93%, I want to gave him 10.000,00 bonus

I make simple example in QV.

I want in straight table in expression to check for example:

     If 94% (Realization %) < 100% (Minimal Realization %) then he get 10.000 bonus

Is this possible to do in expression?

Hope someone can help me

[#2 · Accepted solution]

Stefan,

assuming that bonus grows up when minimal realisation grows up, yu may define chart with:

dimension: EmployeeName

expression (one of):

a) max(if([Realization %]>[Minimal Realization %],[Bonus Amount]))

b) FirstSortedValue([Bonus Amount], if([Realization %]>[Minimal Realization %],-[Minimal Realization %]))

regards

[Gysbert_Wassenaar]

You can use the intervalmatch function. See attached qvw.

[#4]

Gysbert thanks for you quick reply.

It was helpfull, but my problem is I dont know  Realization % in script, I calculate that in straight table expression, and there I want to check in what interval he belongs.

Is this posible at all?

[#5]

You may find alternative approach also here:

Re: pick rating on the fly using calculated score

regards

Darek

[#6]

Txn Dariusz,

Your answer is correct