Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

simple Question, clarification needed! Thanks

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

Highlighted
Not applicable

simple Question, clarification needed! Thanks

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.