How to draw bubble and line in one chart?

[#1]

Anyone know how to draw bubble and line in one chart?

Bubble means the products, radius means the volume.

The step chart is to show the score limit.

My colleague draw this chart in excel.

Now I need to achieve this chart in Qlik View.

How to draw bubble and line in one chart?

[avinashelite]

Try with the Grid / Scatter chart option in QV the exact representation might not be possible but I will give you a close representation 

[rahulpawarb · Accepted solution]

Hello Cai,

As per design you can not have Scatter Chart(Bubble) and Line Chart in a single Chart. In Line Chart we define dimensions (X - Axis) and required measures (Y- Axis); whereas Scatter Chart demands expressions for for X, Y, & Z Axis.

As a workaround, you can create a line chart as well as scatter chart. Change the Transparency of scatter chart to 100% and Layer to Top and place it over to line chart.

Regards!

Rahul Pawar

[#4]

Can the Grid show like the step chart???

[#5]

Can I change the two chart at the same time? For example someone want to chose one area of the chart to see the details.

[rahulpawarb]

As said earlier, the chart which is using Top layer will be available to make selections; those selections will gets reflected to other chart objects (QlikView Associative Model). Adding more to it, if you make a filter selection from outside of the chart then both the charts will respond to that selection.

Regards!

Rahul Pawar

[#7]

Thank you very much!!!

[avinashelite]

With this approach , you need to be really careful while placing the charts because once you make the selection the position of the line and bubbles may not be in sync and it would be hard to maintain .

[#9]

How to restrict the axis of the two chart change synchronous？？

[rahulpawarb]

Could you please elaborate more on this?