Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qmcmullen
Contributor
Contributor

scatter chart with categorical axis

New to QlikView (Personal Edition).  I'm trying to make a scatter plot that shows individual values with a categorical x-axis.  

Given data like:

LOAD * INLINE [
X, Y , ID
1, 10, 1
1, 11, 2
2, 20, 3
2, 21, 4
30, 10, 5
30, 11, 6
];

I want a scatter plot that shows 6 points, with values 1, 2, 30 on the x-axis.

My current attempt is:

plot.png

Which I'm reasonably happy with.

I don't think I can make that with a scatter chart, because scatter chart seems to require a continuous variable for the x-axis.

So I made it with a line chart, with X as the first dimension,  ID as the second dimension, and sum(Y) as the expression.

Because ID is unique to each record, I get a dot for each ID rather than a line.

Questions:

  1. Is this a reasonable way to do this, or is there an easier way?  
  2. Is there a way to avoid having the dots colored by ID?  That is, I want all dots to have the same color.  Without knowing in advance the number of dots.
  3. Seems like even with a scatter plot, if I want to show unique values, I need to have an unique ID as a a dimension, to prevent aggregation, is that right?

Thanks,

--Q.

Labels (1)
1 Solution

Accepted Solutions
Claudiu_Anghelescu
Specialist
Specialist

 
To help community find solutions, please don't forget to mark as correct.

View solution in original post

4 Replies
Claudiu_Anghelescu
Specialist
Specialist

See this document.

To help community find solutions, please don't forget to mark as correct.
qmcmullen
Contributor
Contributor
Author

Thanks @Claudiu_Anghelescu  .  Sadly, since I'm on the personal / learner edition, I can't open .qvw files created by others.  If you have time, can you describe the approach in words or screenshots?

Claudiu_Anghelescu
Specialist
Specialist

 
To help community find solutions, please don't forget to mark as correct.
qmcmullen
Contributor
Contributor
Author

Thanks @Claudiu_Anghelescu .  That definitely helps with the symbol colors.  I was stuck over at the colors tab. : )