Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator III
Creator III

Block Chart & Background Colours

Hi,

i want to display 12 values (12 business Key Performance indicators) in a block chart. I want the background colour of each KPI block to reflect how the KPI is performing to Target I.e.

Under 50%: Background Colour = Red()

50% to 90%: Background Colour = Amber()

90%+: Background Colour = Green()

there's no expression as such, no calculation so i guess i'll just use Count(1) in the expression, with the dimension being the KPI's

Dept.KPIActualTarget
AKPI1$75$100
AKPI2$1000$3000
AKPI3$200$150

do i have to use an expression for each KPI? and add something to the background colour of each expression?

cheers

3 Replies
wonkymeister
Creator III
Creator III
Author

basically,

is it possible to specify the colour of each individual block?

giakoum
Partner - Master II
Partner - Master II

KPI1 has value Actual $75

where is that coming from if not an expression, even if it is Only(Actual)?

Based on that, you can set the color as desired

wonkymeister
Creator III
Creator III
Author

the data is already calculated prior to load.

i understand where your coming from now - i was trying to save time and have the calculation already done in the dataset - save me doing the calculation in the chart.