topic simple Question, clarification needed! Thanks in QlikView

simple Question, clarification needed! Thanks

Thu, 10 Sep 2009 23:37:32 GMT

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.

simple Question, clarification needed! Thanks

disqr_rm — Fri, 11 Sep 2009 00:59:11 GMT

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

simple Question, clarification needed! Thanks

Mon, 14 Sep 2009 15:28:04 GMT

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.