Expression error - maps

[#1]

Hi,

Can anyone help with what might be wrong with this expression? We have a Qlikmap where we would like this data to be shown in different colours:

= If(sum([Decency]) =Non-decent,'#FFF042',
= If(sum([Refusal]) =No,'#FF0000',

Cheers

Chris

[Gysbert_Wassenaar]

Well, that looks like parts of two expressions. Both of which are not closed. And you're comparing a sum to ... a field? ...an expression? ...a variable? And a color can't be specified as a string containing something that looks like a hexidecimal number.

Is something like this what you're trying to do?

= If(sum([Decency]) =200,rgb(255,240,66),  If(sum([Refusal?]) =300,rgb(255,0,0)))

[#3]

Hi Gysbert,

Please see file attached. Its still says bad field names.

Cheers

Chris

[#4 · Accepted solution]

Chris,

try this expression in your application:

= If([Decency]='Non-decent','#FFF042', If([Refusal?]='No','#FF0000'))

This works fine with me. Attached your edited file.

Greetz,

Marc