Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did you checked Chart Properties ----> Number?
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
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.
Do you have some questions about the solution ?
no thanks
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()