Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor II

pie chart

    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

6 Replies
Not applicable

Re: pie chart

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

senpradip007
Valued Contributor III

Re: pie chart

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

whiteline
Honored Contributor II

Re: pie chart

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.

whiteline
Honored Contributor II

Re: pie chart

Do you have some questions about the solution ?

QSense
Contributor II

Re: pie chart

no thanks

Not applicable

Re: pie chart

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

Community Browser