Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Use the field that unique identifies an individual sale as dimension.
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
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
That's great hint, will play around with it. Appreciate your help.
Thanks.
Kelley