Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

simple Question, clarification needed! Thanks

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.





2 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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.