Map Layers - Color Code

Carlos2 — Sat, 16 Nov 2024 18:00:53 GMT

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

Re: Map Layers - Color Code

Fernando_Fabregas — Tue, 06 Oct 2020 18:13:17 GMT

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

topic Re: Map Layers - Color Code in QlikView

Map Layers - Color Code

Re: Map Layers - Color Code