topic Re: a scatter plot challenge in QlikView

a scatter plot challenge

Tue, 07 May 2013 18:51:10 GMT

My file is quite simple

- City

- Country

- v1

- v2

Each city belongs in one county. A country is a set of cities ! v1 & v2 are 2 numeric variable.

I created a scatter very easily.

My scatter doesn't depend of the selection of a city.

To achieve this, my expressions are sum( {1} V1) and sum( {1} V2).

I'd like to design my scatter plot with a color coding

An user choose a city in a list box then I'd like to get

- selected city in Blue

- cities of the county where the selected city belongs in red

- other cities in grey

I know to color only the selected city with

=if( GetFieldSelections(City)=City , color(1) , color(2))

but I don't know to colorize the others in 2 groups

Thanks for your help

Gysbert_Wassenaar — Tue, 07 May 2013 19:08:37 GMT

See attached example.

Tue, 07 May 2013 19:18:25 GMT

Thanks Gysbert

Nice expression

=count({<City=p({<City=,Country=p(Country)>}City)>}City)

regards

Thu, 06 Jun 2013 20:41:29 GMT

How to add the first dimension legend and colur code also based on the First Dim legend ?