topic Re: Calculating Percentage on a Bar Chart in QlikView

Calculating Percentage on a Bar Chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I'm new user and am building a horizontal bar chart that I would like to show the total number of awards for each award category and the percentage of total awards for each category as a label. The Category Field is my dimension.

I was honing in the Category field to perform the calculations, but I can't get the percentage to calculate correctly.

I was hoping for some suggestions in calculating the percentage of awards for each category using the attached sample data.

Any help is appreciated!

Thanks!

Pat

Re: Calculating Percentage on a Bar Chart

ahaahaaha — Tue, 09 May 2017 07:15:24 GMT

Hi Patrick,

May be like this

Dimension: Category,

Expression: Count(Category)/Count(TOTAL Category)

and on the tab "Number" of chart set the readings in percent.

Regards,

Andrey

Re: Calculating Percentage on a Bar Chart

prieper — Tue, 09 May 2017 07:25:44 GMT

Create another expression with text on Axis and an expression like

COUNT(Award) / COUNT(TOTAL Award)

Which counts the number of awards, subject to Dimensions shown in relation to the total count

Peter

Re: Calculating Percentage on a Bar Chart

Tue, 09 May 2017 13:31:36 GMT

Andrey and Peter -

Thanks so much for your assistance and quick reply! Your advice worked like a charm!

Much appreciated!

Pat

Re: Calculating Percentage on a Bar Chart

abdul_mo — Fri, 23 Nov 2018 09:58:45 GMT

thanks alot Andery