Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
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
JJ
See attached example.
Thanks Gysbert
Nice expression
=count({<City=p({<City=,Country=p(Country)>}City)>}City)
regards
JJ
How to add the first dimension legend and colur code also based on the First Dim legend ?