Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

btaub
New Contributor III

Sense - Not all dims showing in scatter plot

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

Tags (2)
1 Solution

Accepted Solutions
reddys310
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

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

7 Replies
reddys310
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

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.

btaub
New Contributor III

Re: Sense - Not all dims showing in scatter plot

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

reddys310
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

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

reddys310
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

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

ogster1974
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

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

btaub
New Contributor III

Re: Sense - Not all dims showing in scatter plot

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

reddys310
Honored Contributor II

Re: Sense - Not all dims showing in scatter plot

Always Welcome!