topic Pie Chart: Can one view % and count simultaneously? in QlikView

Pie Chart: Can one view % and count simultaneously?

Tue, 13 Apr 2010 15:26:02 GMT

I would like my Pie Chart to simultaneously show me the count of values, and what % that count makes of the overall Pie Chart. At the moment, all I can get is one or the other.

Thanks

Daniel

Pie Chart: Can one view % and count simultaneously?

Tue, 13 Apr 2010 15:29:45 GMT

Hello, you can go to the presentation tab and add a new "text in chart" expression to either display % or count. This will create an extra label, apart of what is shown in the chart already.

Regards

Pie Chart: Can one view % and count simultaneously?

Tue, 13 Apr 2010 15:51:35 GMT

Hi Daniel,

try DUAL function, like this:

Dual(

Num(Sum(sales)/Sum(Total sale),'0.00%') & chr(13) & Num(Sum(sales),'#,##0'),

Sum(sales)

)

with flag "values on data points"

Alex