Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

ChartSam.png

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)

zoom11.png

kkkumar82
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

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

kkkumar82
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 picpercentages.png

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

Snip.PNG

kkkumar82
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.

kkkumar82
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

kkkumar82
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