# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save \$300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
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

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

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

Valued Contributor III

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

Hi Gotham,

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

Highlighted
Not applicable

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

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

Valued Contributor III

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

Write the formula like

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

Not applicable

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

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

Valued Contributor III

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

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.

Valued Contributor III

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

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

Not applicable

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

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

Valued Contributor III

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

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