topic Re: Interval in expression in QlikView

Interval in expression

Tue, 03 Jun 2014 08:31:15 GMT

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

Re: Interval in expression

Tue, 03 Jun 2014 08:45:31 GMT

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

Re: Interval in expression

Gysbert_Wassenaar — Tue, 03 Jun 2014 08:46:14 GMT

You can use the intervalmatch function. See attached qvw.

Re: Interval in expression

Tue, 03 Jun 2014 08:57:20 GMT

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?

Re: Interval in expression

Tue, 03 Jun 2014 09:04:30 GMT

You may find alternative approach also here:

Re: pick rating on the fly using calculated score

regards

Darek

Re: Interval in expression

Tue, 03 Jun 2014 09:12:00 GMT

Txn Dariusz,

Your answer is correct