Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to draw bubble and line in one chart?

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.

bubble1.PNG

1 Solution

Accepted Solutions
rahulpawarb
Specialist III
Specialist III

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

View solution in original post

14 Replies
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
Specialist III
Specialist III

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

View solution in original post

Not applicable
Author

Can the Grid show like the step chart???

Not applicable
Author

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
Specialist III
Specialist III

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

Not applicable
Author

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 .

Not applicable
Author

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

rahulpawarb
Specialist III
Specialist III

Could you please elaborate more on this?