Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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

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

senpradip007
Specialist III
Specialist III

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
Master II
Master II

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
Master II
Master II

Do you have some questions about the solution ?

QSense
Creator II
Creator II
Author

no thanks

Not applicable

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