topic Re: question about scatter plot in Qlik Sense in App Development

question about scatter plot in Qlik Sense

Wed, 30 Mar 2016 16:11:55 GMT

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

Re: question about scatter plot in Qlik Sense

Gysbert_Wassenaar — Wed, 30 Mar 2016 16:37:51 GMT

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

Re: question about scatter plot in Qlik Sense

Wed, 30 Mar 2016 18:01:34 GMT

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

Re: question about scatter plot in Qlik Sense

Gysbert_Wassenaar — Wed, 30 Mar 2016 18:12:40 GMT

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

Re: question about scatter plot in Qlik Sense

Wed, 30 Mar 2016 19:47:34 GMT

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

Thanks.

Kelley