Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Thanks,
--Q.
See this document.
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?
Thanks @Claudiu_Anghelescu . That definitely helps with the symbol colors. I was stuck over at the colors tab. : )