topic AW:Select locations and visualize user entry in scatter chart in QlikView

Select locations and visualize user entry in scatter chart

Mon, 09 Aug 2010 17:19:43 GMT

Hi,

I need to select a number of locations (lets say 25) from a locations table which hold ZIP, GPS-Lon, GPS-Lat.

I then need to visualize 25 manual user entries (representing a radius each) as dot sizes.

How can I collect user input (one for each selected location) and "bind" it to those 10 locations so that I can have a nice scatter chart (locations map)?

Best regards,
Georg

AW:Select locations and visualize user entry in scatter chart

brenner_martina — Mon, 09 Aug 2010 17:48:43 GMT

Hi Georg,

you must enter at the beginning of your script:

Inputfield Fieldname;

than enter in the Table with the locations:

Load ...,
0 as Fieldname,
...
From ...;

or, if you want to preset your Fieldname with a value:

Load ...,
Valuefiled as Fieldname,
...
From ...;

Now you can enter in your tablechart or pivottable the new Filedname and use here the expression:

Inputsum(Fieldname,'*')

if you want to calculate these values.

AW:Select locations and visualize user entry in scatter chart

Mon, 09 Aug 2010 19:28:31 GMT

Thanks Martina, that was exactly what I missed!

Best regards,
Georg