Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator
Creator

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
Creator
Author

basically,

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

giakoum
Partner
Partner

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
Creator
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.