topic Percentage Display in QlikView

Percentage Display

Tue, 05 May 2009 21:28:10 GMT

Hi,

is it possible to display values like 0,00323 as percentage like 0,32% in a chart. My chart only shows 0%.
Thanks

Anonymous — Tue, 05 May 2009 22:19:03 GMT

Sure it is possible.
On the number tab, in addition to checking "Show in Percent", also select "Fixed To", and add more decimals.

Wed, 06 May 2009 14:00:10 GMT

That's what I tried but I'm still having problems with it. The chart always shows a rounded percentage.

I tried the following:

Test:
LOAD * INLINE [
Value, Amount
A, 57
B, 212
C, 24
D, 119
];

BarChart with Dimension Value, and Expression: Sum(Amount)/SUM(ALL Amount)

The result is 14%, 51%, 6%, 29% although it should be eg. 28,884%

No changing by editing in numbers.

Regards.

sparur — Wed, 06 May 2009 15:00:25 GMT

Hi, Aloah

try that:

Chart properties / Expression Tab / Display Options and check "Text on Data Points"!

P.S. see in attachment