topic Re: calculate in percentage ? in QlikView

calculate in percentage ?

suvechha_b — Tue, 10 Sep 2013 10:15:23 GMT

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 ??

Re: calculate in percentage ?

suvechha_b — Tue, 10 Sep 2013 10:16:37 GMT

Attaching the formula

Re: calculate in percentage ?

Peter_Cammaert — Tue, 10 Sep 2013 10:18:27 GMT

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

Re: calculate in percentage ?

Tue, 10 Sep 2013 10:49:11 GMT

HI,

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

Re: calculate in percentage ?

suvechha_b — Tue, 10 Sep 2013 11:08:19 GMT

can you please suggest how to write this :

result = max(0,100 % - f )

in qlikview expression

Re: calculate in percentage ?

suvechha_b — Tue, 10 Sep 2013 11:08:28 GMT

can you please suggest how to write this :

result = max(0,100 % - f )

in qlikview expression

Re: calculate in percentage ?

Peter_Cammaert — Tue, 10 Sep 2013 11:14:07 GMT

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.)

Re: calculate in percentage ?

Anonymous — Tue, 10 Sep 2013 18:22:41 GMT

rangemax(0, 1-f)