question about scatter plot in Qlik Sense

[#1]

Hi Guru,

I have a question about using scatter plot in Qlik Sense.

Basically I want to display how product is sold throughout the past 20 years.

Use dimension 'Product', my measure is Year and Total sales.

I noticed when one product is sold twice, I cannot render dot two times.

I have to use minimum Year and Sum total sales to at least display one dot.

How can I show 2 dots in this case, is that using scatter plot the right way?

Any other chart can I use to achieve displaying similar timeline event?

Thanks.

Kelley

[Gysbert_Wassenaar]

Use the field that unique identifies an individual sale as dimension.

[#3]

Thanks Gysbert, in my case, I need to use 2 dimensions to identify an unique sale, would that be still possible to use scatter plot then?

Kelley

[Gysbert_Wassenaar · Accepted solution]

You'd have to combine them into one dimension. That's best done by creating a new field in the load script. But you could try a calculated dimension: =Dim1 & '-' & Dim2

[#5]

That's great hint, will play around with it. Appreciate your help.

Thanks.

Kelley