Bubble Graphs - Comparing 2 periods on same graph

[JustinM]

Hi

Is it possible to do a Bubble Graph with comparative bubbles?

For example with the following data: Growth is X axis, Margin is Y axis and Sales is Bubble size with each department being a bubble

Year 1
	Dept 1	Dept 2	Dept 3
Growth	10%	9%	5%
Margin	20%	25%	10%
Sales	1000	1500	400
Year 2
	Dept 1	Dept 2	Dept 3
Growth	8%	12%	10%
Margin	20%	25%	6%
Sales	1200	1000	600

I can do each year on a separate graph but would ideally have both years on the same graph for comparison?

Any help much appreciated

[rubenmarin]

Hi, maybe using for dimesnon a combined key of Dep and year, so each one is a different and use a trick like this one (https://qlikviewcookbook.com/2014/01/a-color-trick/) to make the last year bubbles have the same dep color but more transparent.

There is also the option to use a map to simulate a scatter with track lines, follow "scatter with trackline" example of this post: https://community.qlik.com/t5/Qlik-Sense-Documents/Top-10-Viz-tips-part-III-QlikWorld-2020/ta-p/1679...