topic Re: Sense - Not all dims showing in scatter plot in App Development

Sense - Not all dims showing in scatter plot

Anonymous — Fri, 29 Jan 2016 19:52:50 GMT

Hi! I have a scatter plot in Qlik Sense and I'm having trouble getting all of my dimensions to show on it. Before you ask, yes, there are less than 1000 dim elements (I think the total is around 200). FWIW, the Y axis shows avg employee age, the X axis shows avg salary, and the dimension is department.

The value that I know is missing for sure should be the highest salary, way to the right on the X axis (it's the org's president's department). But, even if I drag the chart to the left, the value doesn't appear. Interesting, though, if I filter my data to only the president's department, then his department appears on the chart (it's a drill dimension so what I then see are the job titles for his department).

Does this sound familiar? Any ideas on how to get all the dims to appear on the chart?

Thanks!

Ben

Re: Sense - Not all dims showing in scatter plot

reddy-s — Sat, 30 Jan 2016 17:48:12 GMT

Hi Benjamin,

This sounds strange. Never happened with me. Are you making use of 3 measures(Where the third measure is the size of the bubble). If so, if the third measure is zero it would be displayed as a "X" on the plot. This could be a reason so that you are not able to spot it.

Thanks,

Sangram.

Re: Sense - Not all dims showing in scatter plot

Anonymous — Mon, 01 Feb 2016 13:31:17 GMT

Hi, Sangram, thanks for the idea but I have no 3rd measure. I just manually set the bubble size.

Re: Sense - Not all dims showing in scatter plot

reddy-s — Mon, 01 Feb 2016 13:50:21 GMT

Analyse the data using filters or a table to check the ones which are missing. This should help you to trouble shoot the issue.

Thanks,

Sangram

Re: Sense - Not all dims showing in scatter plot

reddy-s — Mon, 01 Feb 2016 15:24:45 GMT

Hi Benjamin, I would analyse the data using a table and see if the values are nulls or zeros.

Re: Sense - Not all dims showing in scatter plot

ogster1974 — Mon, 01 Feb 2016 17:17:22 GMT

There is a limit to number of points currently able to be displayed in a scatter chart see here for details.

Re: Sense Limitations - Number of points in a scatter plot

Re: Sense - Not all dims showing in scatter plot

Anonymous — Mon, 08 Feb 2016 13:45:14 GMT

You got it, Sangram. When I changed the chart to be a table it showed that the data for some of the dimension elements was null on one of the measures. That caused it to not show in the chart.

Thanks for the help!

Ben

Re: Sense - Not all dims showing in scatter plot

reddy-s — Mon, 08 Feb 2016 17:45:00 GMT

Always Welcome!