Please Suggest

[suvechha_b]

How to write it in qlikview?

max(100%-f)

Note:

f=e/b

I have already calculated f

[suvechha_b]

sorry i have given the expression wrong :

the expression will be :

max(0,100 %- f)

How to write it in qlikview ?

[CELAMBARASAN]

I guess you need something like this

RangeMax(0, 1-f)

Can you explain your requirement if it is not?

[suvechha_b]

How to write the expression in qlikview ?

max( 0, 100 % - f )

Note:

f= e/b

I have already calculated f

[suvechha_b]

i.e max ( 0 , -20 )

result will be 0 %

again if

max( 0, 50)

result will be 50 %

now, hw to get -20 or 50

it is calculated by ( 100 % - f)

[CELAMBARASAN]

Try with this

RangeMax(0, 100-f)