topic Re: script error in QlikView

script error

Tue, 16 Jul 2013 06:49:53 GMT

Hi,

Can anyone advise how this script can be corrected:

=Sum(Enforcement)='COMPLIANCE''#0000FF'

=Sum(Enforcement)='ENFORCEMENT''#000000'

This first sentence works fine on its own; however, add the second and it says 'Garbage after expression "-"'

Any help would be appreciated

Chris

Tue, 16 Jul 2013 07:02:20 GMT

why have u written script like this?

is it expression?

Where did u write the expression?

Tue, 16 Jul 2013 07:13:37 GMT

Is it the 'colour expression' within our Map properties....we want to colour the results by either ENFORCEMENT or COMPLIANCE.

Cheers

Chris

er_mohit — Tue, 16 Jul 2013 07:51:25 GMT

try this

sum(if(wildmatch(Enforcement,'COMPLIANCE''#0000FF','ENFORCEMENT''#000000'),Enforcement))

sum(if(Enforcement='COMPLIANCE''#0000FF' or Enforcement='ENFORCEMENT''#000000',Enforcement))