simple Question, clarification needed! Thanks

[#1]

Hi guys,

I have a simple colourisation code as follows:

if

 (Count($(KPI_Red)) = 1, rgb(255,0,0
),
(
 if(count($(KPI_Amber)) = 1, rgb(255,128,0
),
rgb

 (51,204,128)
)
)
)

I was wondering that because I have put rgb(255,0,0) in the first line will red take precedence when Qlikview interprets results? I would like it to do so but I am unsure if it is calcultating in this way. Could anyone confirm please? ie if I have 2 results, one is red and one is amber, and I am displaying the count for this (which is 2), I would like the cell to be coloured red.

I appreciate any help,

thanks.

[disqr_rm]

I don't understand why you are using count? What are the values in the field mentioned under KPI_Red or KPI_Amber?

[#3]

KPI_red and Amber are two columns which have a one or zero in each cell. So therefore if there is a one in KPI_Red, the KPI_Amber cell will be 0 and vice versa.