Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead 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

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
Author

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

zoom11.png

kkkumar82
Specialist III
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

kkkumar82
Specialist III
Specialist III

Write the formula like

Sum(Sales)/Sum(Total Sales) and follow the below picpercentages.png

Not applicable
Author

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

Snip.PNG

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

kkkumar82
Specialist III
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

kkkumar82
Specialist III
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