topic Re: pie chart in QlikView

pie chart

QSense — Tue, 28 Aug 2012 07:22:27 GMT

hello

I have a pie chart in expression , I duplicated expression(count(ID)) for show both percent and number

but ı cant show number just it appears in percent

Re: pie chart

Tue, 28 Aug 2012 07:56:08 GMT

did you checked Chart Properties ----> Number?

Re: pie chart

senpradip007 — Tue, 28 Aug 2012 09:01:11 GMT

Hi qliekview,

First of all you can't show number and percent simultaneously. You can show the number or percentage in the legend under Presentation Tab.

Regards

PRADIP

Re: pie chart

whiteline — Tue, 28 Aug 2012 09:23:39 GMT

Hi.

To show values in complex formats you can use dual function.

It creates complex value that has both numerical and text representation.

For example in your case

=dual(num(Count(ID),'0') &' or '& num(Count(ID)/Count(total ID)*100,'0 percent'), Count(ID))

For drawing a pie QlikView will use numerical value and for showing "Text on Data Points" or "Show Numbers In Legend" it will use text representation.

Re: pie chart

whiteline — Wed, 29 Aug 2012 11:51:16 GMT

Do you have some questions about the solution ?

Re: pie chart

QSense — Wed, 29 Aug 2012 11:57:13 GMT

no thanks

Re: pie chart

Wed, 19 Feb 2014 15:48:10 GMT

Hi,

Could you please upload a sample file? I am trying to solve the same problem but unable to resolve. My legend does not display the text representation of DUAL()