Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

wonkymeister
Contributor

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

Tags (1)
3 Replies
wonkymeister
Contributor

Re: Block Chart & Background Colours

basically,

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

giakoum
Honored Contributor II

Re: Block Chart & Background Colours

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
Contributor

Re: Block Chart & Background Colours

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.

Community Browser