topic Re: scatter chart with categorical axis in QlikView

scatter chart with categorical axis

qmcmullen — Sat, 16 Nov 2024 02:50:10 GMT

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:

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:

Is this a reasonable way to do this, or is there an easier way?
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.
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.

Re: scatter chart with categorical axis

Claudiu_Anghelescu — Fri, 02 Aug 2019 13:18:00 GMT

See this document.

Re: scatter chart with categorical axis

qmcmullen — Fri, 02 Aug 2019 15:27:12 GMT

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?

Re: scatter chart with categorical axis

Claudiu_Anghelescu — Mon, 05 Aug 2019 08:56:53 GMT

Re: scatter chart with categorical axis

qmcmullen — Tue, 06 Aug 2019 17:39:10 GMT

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