# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator

## Getting a Percent of Total in Bar Graph

I need to do the following in a bar graph:

We have 2 locations and I need to be able to have products on the X-Axis. Each Product will have two bars (one for each location). However the bar for that location will represent only the % of total for that specific location.

As an Example:

Location A total sales = 1,000

Location B total sales = 500

Product A sales for location A = 200

Product A sales for location B = 50

So from the example above:

The bar for location A / Product A would = 200/1000 or 20% for that particular bar

The bar for location B / Product A would = 50/500 or 10% for that particular bar

How would the set analysis work to get sales for a product/ocation dividied by total sales for a location/ all products.

1 Solution

Accepted Solutions

Hi,

Try this.

Create a bar chart with dimension as product. and expression as below

Sum(Sales)/ sum (total <Location> Sales)

Regards,

Kaushik Solanki

Regards,
Kaushik
4 Replies
Not applicable

Right click on the chart > Properties > Number > Select 'Integer' and then select the 'Show in Percent (%)' checkbox. This should solve the issue.

Creator
Author

thanks for the feedback. That doesn't solve it because it is showing the percent across all point on the graph. I need it to show the % of total based on EACH locations total.

Hi,

Try this.

Create a bar chart with dimension as product. and expression as below

Sum(Sales)/ sum (total <Location> Sales)

Regards,

Kaushik Solanki

Regards,
Kaushik