Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 8000+ points of sales and they are divided into three groups (column name = AREA_COBERTURA) which are "DAVID", "PANAMA", "CENTRALES" and I want to set three different colors in the map based on [AREA_COBERTURA]
I already tried in the colors tab under the layer to put a if function and it gives me error
IF([AREA_COBERTURA] = "DAVID", red(),
[AREA_COBERTURA] = "PANAMA", blue (),
[AREA_COBERTURA] = "DAVID", green())
This approach under expression gives me error.
Please help
Hi Carlos, if() accepts only one or two results. You must put nested IFs to get 3 or more results.
Try this:
IF( [AREA_COBERTURA] = "DAVID", red(),
IF( [AREA_COBERTURA] = "PANAMA", blue(), green() ) )
Regards, Fernando
Hi Carlos, if() accepts only one or two results. You must put nested IFs to get 3 or more results.
Try this:
IF( [AREA_COBERTURA] = "DAVID", red(),
IF( [AREA_COBERTURA] = "PANAMA", blue(), green() ) )
Regards, Fernando