Showing value on data point and percents in Pie Chart!

[#1]

Hi!

I have to values, Answ Calls and Aband Calls.

I have made a Pie Chart without dimensions.

Then i have two expressions, Sum(answcalls) and Sum(abandcalls).

But when i choose "Values on data points" i only get the value on Answcalls and not abandcalls.

Also when i take "Show i Percent (%)" i get 54 200%..

And if i choose Relative it still does not work.

Any help?

Thanks

[tresesco]

Could you share your sample app?

[#3]

Nope im on a private licens and connected to a ODBC

[tresesco]

Still you can. See here : http://community.qlik.com/docs/DOC-1290

[#5]

On the expression after Sum(answcalls) / 100 & choose the relative. On the number tab, check show in percent.

You should be able to get the % correctly.

[sudeepkm]

Is there any specific reason you want to use PIE chart. I think if you have a requirement to not use dimension then better to go for Gauge charts. Have two Gauge charts for your expressions. Better if you can post a sample qvw.

[veidlburkhard]

Hi Erik,

I had the same problem that a pie chart with two expressions and no dimension will show one value, only.

I solved the problem this way.

1. Solution: go to 'Presentation' tab and mark the 'Show Legend' and 'Show Numbers in Legend' check boxes.

2, Solution: Add an expression into the 'Text in Chart' menu. Enter just that expression which does not show the value on datapoints. By default this text is place on top left of the chart. Press Ctr + Shift and drag it to the right position.

See a simple example below:

Hope this helps

Burkhard