Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
rangemax(0, 1-f)
Attaching the formula
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
HI,
Properties->Number tab->select the expression-> and select ->Show in percentage
can you please suggest how to write this :
result = max(0,100 % - f )
in qlikview expression
can you please suggest how to write this :
result = max(0,100 % - f )
in qlikview expression
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.)
rangemax(0, 1-f)