script

[#1]

Hi,

Hoping anybody could advise why the below script won't work? We have this on one application where it works fine for the Qlikmap and shows different colours for each satisfaction score.

However, when I have copied this over to a simiar app nothing happens. It says 'expression is ok' but still nothing. Any help would be great?:

=

if(if($(question) ='N/A',0,$(question)) = 10, '#4AA02C',

if(if($(question) ='N/A',0,$(question)) = 9, '#7CD25E',

if(if($(question) ='N/A',0,$(question)) = 8, '#CDCD00',

if(if($(question) ='N/A',0,$(question)) = 7, '#FFFF00',

if(if($(question) ='N/A',0,$(question)) = 6, '#0000FF',

if(if($(question) ='N/A',0,$(question)) = 5, '#0000FF',

if(if($(question) ='N/A',0,$(question)) = 4, '#CD4646', '#FF0000')))))))

Chris

[Miguel_Angel_Baeyens]

Hi Chris,

Does the "question" variable exist in the new document? If so, how it is defined?

Miguel