Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scatter chart shows unexpected behaviour

Hi

I have tried to understand scatter charts in qlik but am stuck now as I can not see how it works.

I am using a simple table with id, x, y, cat fields

LOAD * INLINE [
id,x, y, cat
1,5, 5, 11
2,7, 6, 12
3,10, 6, 12
4,8, 6, 12
5,3, 5, 15
6,3, 4, 16
7,3, 3, 17
8,3, 2, 18
9,3, 1, 19
10,4, 1,20
11,4,2,5
12,4,3,5
13,4,4,5
14,4,5,5
15,4,6,5
];

I create a scatter chart and assign cat as dimension, x and y as expression.

This shows correct results only for data that has a unique category value. For the category 5 and 12, which have multiple positions, the chart shows nothing.

If I add the id field as first dimension (category second) the chart looks correct but only as long as I have more then one category in my selected data. Making a single category selection removes the category from the chart, shows the id as legend and assigns symbols/colors based on id instead of category.

Any workaround for this?

Thanks

Jürg

11 Replies
Not applicable
Author

Hi John

It was a requirement to show different objects and events on a map background and have the symbol represent the type of object / event, yes.

However my customer wanted more than 20 different symbols / icons and making them freely assignable to the object/event types. In addition not only fixed icons but also small diagrams showing variable values, some rotated to fit to the street direction - so rather in the way of using shape files to define the symbol.

Also the examples with the map would need to be extended to react to panning and zooming so not only showing points based on selections but impact selections based on map changes.

I was referring to the "edge" because a lot of calculation for the map representation is in the user code and not "inherent" to Qlik.

Jürg

Not applicable
Author

I was able to figure it out after further tinkering. I had an issue in one of the calculated expressions that prevented the multiple instances to be aggregated correctly. Since they were not aggregating/summing, they wouldnt display at all.