Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I don't understand why you are using count? What are the values in the field mentioned under KPI_Red or KPI_Amber?
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.