calculate in percentage ?

[suvechha_b]

How to calculate :

result = max(0,100 % - f )

NB:

f = Sum([Absolute Error])/Sum([Actual Units])

how to calculate f in percentage ?? and also result in percentage ??

[suvechha_b]

Attaching the formula

[Peter_Cammaert]

Calculations of values intended to be displayed as percentages should produce fractions between 0 and 1 (or higher if you want to go beyond 100%). In the Properties->Number tab of a table, graph or other object you can specify that they should be shown as percentages.

Peter

[#4]

HI,

Properties->Number tab->select the expression-> and select ->Show in percentage

[suvechha_b]

can you please suggest how to write this :

result = max(0,100 % - f )

in qlikview expression

[suvechha_b]

can you please suggest how to write this :

result = max(0,100 % - f )

in qlikview expression

[Peter_Cammaert]

If we suppose that f lies between 0 and 1, then use

=rangemax(0, 1 - f)

As I said, internally QlikView likes to handle percentages as fractions between 0 and 1 whereby 0 means 0% and 1 = 100%. Only when you want to visualize these values, you enable Show as Percentage in Properties->Number.

Peter

(Sorry, rangemax.I stand corrected.)

[Anonymous · Accepted solution]

rangemax(0, 1-f)