# App Development

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for
Did you mean:  Specialist

## 100% stacked graph from a percentage stacked graph

sum({<FIN_YR_NO = {"<=\$(vMaxFinYr)"}, MTH_SHORT_DESC=>}\$(vMeasure_FieldName))
/
sum({<FIN_YR_NO = {"<=\$(vMaxFinYr)"},Milestone={'Intake'}, MTH_SHORT_DESC=>}\$(vMeasure_FieldName))

Good day

Below is my expression for a % stacked graph , how do i convert this graph into a 100% stacked graph ?

Labels (1)
• ### App Development

1 Solution

Accepted Solutions  Partner

See the attachment. I've added another formula as test and added a type so you can clearly see the difference.

Jordy

Climber

Work smarter, not harder
9 Replies  Partner

Hi,

You need TOTAL for this. Check this video.

Jordy

Climber

Work smarter, not harder  Specialist
Author

I had many other graphs that were just numbers , i did use total<yr_mth_no> eg it works easily , the problem is this graph is already in percentages and the total <> is not working  Partner

What is the dimension you are using in your graph? You need to include this in your set analysis.

Jordy

Climber

Work smarter, not harder  Specialist
Author
TOTAL <YR_MTH_NO, FIN_YR_NO, MTH_SHORT_DESC, FIN_QTR_NO,Fiscal_Year,Fiscal_YearHalf,Fiscal_Quater,Cal_Day,WEEKNUM,WEEKLABEL,Date, Cal_YearMonth, Cal_DayName>\$(vMeasure_FieldName)),  Partner

Your results should in the following syntax:

``````Sum(\$(vMeasure_FieldName))
/
Sum( TOTAL < [YourDimensionInBarChart] >\$(vMeasure_FieldName))``````

You can expand the part before and after the / . But this is how you will get the 100% stacked charts.

Jordy

Climber

Work smarter, not harder  Specialist
Author

Make the attachment a 100% stacked graph  Partner

See the attachment. I've added another formula as test and added a type so you can clearly see the difference.

Jordy

Climber

Work smarter, not harder  Specialist
Author

What happens if this my formula

(Sum(Contribution) * Sum(GL_VALUE) / count(DISTINCT Cost_Centre)) / count(distinct YR_MTH_NO)

How do i get 100% stacked i tried

YR_MTH_NO is my dimension  Specialist
Author

(Sum(Contribution)/Sum(TOTAL <YR_MTH_NO> Contribution))
* (Sum(GL_VALUE)/Sum(TOTAL <YR_MTH_NO> GL_VALUE))
/ (count(DISTINCT Cost_Centre) / Count (DISTINCT TOTAL <YR_MTH_NO> Cost_Centre))
/ (count(distinct YR_MTH_NO)/(count(TOTAL <YR_MTH_NO> distinct YR_MTH_NO))
) Tags
Community Browser