Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using a ratio in the y-axis (Percentage) of a Scatter Chart.

Hello all,

I'm struggling with using a ratio percentage in the Y-axis. The ratio I'm using is the Contribution Margin Ratio. Essentially it is (Revenue - Cost) / Revenue

My end goal is to have an X-axis of Cost, Y-axis of contribution margin, and a Bubble size of overall Profitability. However, I can't seem to get a percentage for the Y-axis. I think I need to utilize Aggr, but I'm not quite sure. Here is my chart thus far.

Scatter_Chart_example.PNG

I would like the contribution margin ratio to be in place of the Revenue axis.

Here is the formula and variables I'm attempting to use.

Formula: $(vf_OverallProfitability)/$(vf_OverallRevenue)

Variables and definitions:

Profit (Total revenue minus the expenses)

$(vf_OverallProfitability)

(sum({$<[Resource Type] = {'Retained'}>} [#Hours Billed] * #Rate)

-sum({$<[Resource Type] = {'Retained'}>} [#Consultant Retainer Amount Entered]))

+

(sum({$<[Resource Type] = {'Employee'}>} [#Hours Worked] * #Rate)

-sum({$<[Resource Type] = {'Employee'}>} [#Salary Amount Calculated]))

+

(sum({$<[Resource Type] = {'Contractor'}>} [#Hours Worked] * #Rate)

-sum({$<[Resource Type] = {'Contractor'}>} #Amount))

Revenue

$(vf_OverallRevenue)

(sum({$<[Resource Type] = {'Retained'}>} [#Hours Billed] * #Rate))

+

(sum({$<[Resource Type] = {'Employee'}>} [#Hours Worked] * #Rate))

+

(sum({$<[Resource Type] = {'Contractor'}>} [#Hours Worked] * #Rate))

When I use the above formula and variables in the graph I get whole numbers and my data points disappear from the graph.

Any help would be greatly appreciated here, I've been stuck on this problem for 2 days now.

Thanks,

Channing

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe use extra brackets like

( $(vf_OverallProfitability) ) / ( $(vf_OverallRevenue) )

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe use extra brackets like

( $(vf_OverallProfitability) ) / ( $(vf_OverallRevenue) )

Anonymous
Not applicable
Author

Feeling very silly now! Thank you