topic Re: Expression error - maps in QlikView

Expression error - maps

Tue, 02 Apr 2013 11:06:43 GMT

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

Re: Expression error - maps

Gysbert_Wassenaar — Tue, 02 Apr 2013 11:15:05 GMT

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)))

Re: Expression error - maps

Tue, 02 Apr 2013 11:49:33 GMT

Hi Gysbert,

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

Cheers

Chris

Re: Expression error - maps

Tue, 02 Apr 2013 12:58:37 GMT

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