# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Not applicable

## How to get Stacked Barchart with individual percentages and one final absolute value.

Hello All,

I've one sample barchart to explain the problem scenario

From the above barchart:

* I've Dimensions: Type,New_Campaign_Name

Measure=Total

fx=sum(Sum)

* I'm getting Absolute values in front of each bars like 2071,1995 etc.

* Adding to these values i should get individual percentages for each each campaigns in each bars(I mean to say three seperate percentage in first bar)

Changes in expressions Recommented

Thanks

9 Replies
Not applicable
Author

Below is my Bar Chart(if i made it grouped)

Specialist III

Hi Gotham,

I think for now the current version doesn't have this feature

Not applicable
Author

Can we do it by applying formula in the expression,,,

For eg:sum(Sum) we are getting 879,909,283 for the first bar, can we convert into percentage

Specialist III

Write the formula like

Sum(Sales)/Sum(Total Sales) and follow the below pic

Not applicable
Author

Yea i'm getting percentages for individual, but can i get total absolute value at the end like

Specialist III

Based on your pic if for march , if you don't have the second dimension values then there is a chance of getting like that

but in a stacked bar when you have two dimensions then there is no change of getting stacked bar for some bars and for the last bar absolute value.

Specialist III

R u getting the percentages in sense like what you share? if so what have done for that?

Not applicable
Author

No the above pic is just a sample to get the things done.

But the problem here is in stacked we are getting sum-up percentage, can't we get divided percentage for all the campaigns over there

Specialist III

for now no in Sense, but if you have observed if you hover your mouse on the sub parts of bar , you will get the pop up

showing the percentage value

Tags
Community Browser