Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - 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 ?

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

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

View solution in original post

9 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

You need TOTAL for this. Check this video.

Jordy

Climber

Work smarter, not harder
vvvvvvizard
Partner - Specialist
Partner - 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

JordyWegman
Partner - Master
Partner - Master

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
vvvvvvizard
Partner - Specialist
Partner - 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)),
JordyWegman
Partner - Master
Partner - Master

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
vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

Make the attachment a 100% stacked graph  

JordyWegman
Partner - Master
Partner - Master

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
vvvvvvizard
Partner - Specialist
Partner - 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

vvvvvvizard
Partner - Specialist
Partner - 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))
)