Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Specialist
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)
1 Solution

Accepted Solutions
JordyWegman
Partner
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

View solution in original post

9 Replies
JordyWegman
Partner
Partner

Hi,

You need TOTAL for this. Check this video.

Jordy

Climber

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

Make the attachment a 100% stacked graph  

JordyWegman
Partner
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

View solution in original post

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