Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.