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: 
Not applicable

100 Stacked Barchar does not equal 100%

I am really struggling with creating a stacked 100% bar chart.. Here is what my data looks like. I am creating Lender and County as dimensions and MarketShare as my measure.  I am choosing the bar chart option . As you can see from the image, I am not getting the 100% like my data.

   

LenderCountySalesMarketShare
GuildRiverside395412510.08%
GuildLos Angeles813165680.16%
GuildSan Bernardino111677270.02%
All OthersOrange236961250.05%
GuildSan Diego1379309780.27%
All OthersRiverside516662572910.01%
GuildLos Angeles2357240216545.66%
All OthersSan Bernardino37951864107.35%
GuildOrange976208526618.91%
All OthersSan Diego903410362017.50%

100.00%

1 Solution

Accepted Solutions
sunny_talwar

Try this (like I said to calculate the percentage)

Sum(Sales)/Sum(TOTAL <Lender> Sales)

View solution in original post

7 Replies
ecolomer
Master II
Master II

Hi,

Can you explain more your requeriment?

Canyou also upload a simple data for that?

TX

EC

sunny_talwar

What is the expression you are using? Assuming it is Sum(Sales), try this:

Sum(Sales)/Sum(TOTAL <Lender> Sales)

Not applicable
Author

I am loading the data exactly as in the post. My measurement then is simply SUM(Sales).

Not applicable
Author

I have a single lender with sales per county plus All Other lenders with sales per county. I want to see what percentage each lender has per county like the example I created in Excel.

sunny_talwar

Try this (like I said to calculate the percentage)

Sum(Sales)/Sum(TOTAL <Lender> Sales)

ecolomer
Master II
Master II

Use expression writted by Sunny T

Not applicable
Author

Thanks to you both. Works perfect!