Plot two types of data in one scatterplot

[louise119]

Is it possible to draw two types of data in one scatter plot with different plot colors?

[ogster1974]

Perhaps mock-up what your ask is and we can assist you better.

[louise119]

I want to create a scatterplot like the attached image with Qlik.

 

[ogster1974]

Not sure if this is doing what you ask but I have

2 measures qty and sales

by product 

coloured by product group.

Is that the capability you are looking for?

[louise119]

Thank you so much.That is what I want to make.
But the "product" part wants to fetch two items from another table.
For example, I want to use the same measures(2 measures qty and sales) for data a in table A and data b in table B.

[ogster1974]

You can add alternative dimensions to your chart to analyse more through the exploration panel.  In my case having the option of switching between Invoices and Products using the same measures.

[louise119]

Thank you so much. I am currently using Qlik Sense for development.
I would like to display data from two tables by default, is that difficult?

[ogster1974]

its inbuilt in the chart capability itself as an alternate dimension working off the underlying data model so are long as your data model works the chart will function as expected.

[louise119]

Does that mean I can't plot data from two tables at once in a scatterplot?

[ogster1974]

I think if I get your question then for the extra dimension you can either select it as an alternate or use it to color your bubbles if appropriate.

but no you can't have 2 dimension points in the same scatter chart at the same time.  you can either:

1. use 2nd dimension as an alternative

2. colour the point by the 2nd dimension

3. size the point by a 3rd measure