topic Re: How to show Count and Percentage on the Pie chart visual ? in QlikView

How to show Count and Percentage on the Pie chart visual ?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the below Pie Chart which shows the No of Projects per Category;

When I uncheck the relative under my expression I am getting the count of the projects as shown below;

How Can I get both percentages and count of the projects in my Pie chart visual? any help is greatly appreciated.

thanks

Bhavesh

Re: How to show Count and Percentage on the Pie chart visual ?

dplr-rn — Thu, 04 Oct 2018 17:00:38 GMT

You need to use dual function.

something like

dual( your_sum_expression & ' - ' & your_percent_expression,your_sum_expression)

something like

dual(Num(Sum(Sales),'0,000.00') & '-' & num((Sum(Sales)/Sum(TOTAL Sales))*100,'0.00') & '%',

Num(Sum(Sales),'0,000.00'))

Re: How to show Count and Percentage on the Pie chart visual ?

qolkaram — Fri, 05 Oct 2018 03:43:31 GMT

Hi,

just add a calculated dimension as

=Category&' : '& aggr(num(sum(#Projects)/sum(total{<Category>} #Projects),'#,##0.00%'),Category)

and the expression is :

sum(#Projects)

and don't select relative check box .

thanks

nassim

Re: How to show Count and Percentage on the Pie chart visual ?

jensmunnichs — Fri, 05 Oct 2018 08:20:41 GMT

Couple of answers that work here, I find the easiest option to be to simply add a second expression with the exact same expression (for example Count(Project)), and tick relative for one of the expressions and leave it off for the other. Check Value on data points for both and you should have what you want. Example:

You won't be able to see the percentage in the legend though, you'll have to use Nassim's solution for that.

Re: How to show Count and Percentage on the Pie chart visual ?

bhaveshp90 — Fri, 05 Oct 2018 18:18:49 GMT

That was the easiest thing to do. thank you

Re: How to show Count and Percentage on the Pie chart visual ?

samuelll — Tue, 18 Aug 2020 12:00:21 GMT

can this be expanded to a second dimension? so not just "category", but say, "category" and "projectowner" where project owner could be a list of names