Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

coordinates on a bubble chart

Hi all,

thanks for any help on this,

I have some data with some x y positions on them and i want to translate this onto a scatter chart, when i go through the standard chart properties i use time as the dimension and the x y locations as X and Y.

when i go to advanced mode it says sum(posX) and Sum(PosY). obvioulsy this isnt correct as it will sum up the coordinates at that point in time resulting in just one coordinate not all my distinct points.

hopefully what ive said makes sense and you will be able to help.

thanks

1 Reply
Gysbert_Wassenaar

If you have several sets of x,y coordinates per time value then you should not use time as a dimension. If you want to show individual sets of x,y coordinates you need a key that identifies the individual sets. If you don't have that in your data you can easily create that in the load script:

MyData:

LOAD x, y, time, recno() as key FROM ...source...;


talk is cheap, supply exceeds demand