Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Using a ratio in the y-axis (Percentage) of a Scat...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Anonymous

Not applicable

2016-08-08
02:56 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

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

621 Views

1 Solution

Accepted Solutions

swuehl

MVP

2016-08-08
04:04 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Maybe use extra brackets like

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

518 Views

2 Replies

swuehl

MVP

2016-08-08
04:04 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Maybe use extra brackets like

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

519 Views

Anonymous

Not applicable

2016-08-09
09:00 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Feeling very silly now! Thank you

518 Views