topic Re: Block Chart & Background Colours in QlikView

Block Chart & Background Colours

wonkymeister — Mon, 16 Feb 2015 13:08:55 GMT

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.	KPI	Actual	Target
A	KPI1	$75	$100
A	KPI2	$1000	$3000
A	KPI3	$200	$150

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

cheers

Re: Block Chart & Background Colours

wonkymeister — Mon, 16 Feb 2015 15:36:29 GMT

basically,

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

Re: Block Chart & Background Colours

giakoum — Mon, 16 Feb 2015 15:40:17 GMT

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

Re: Block Chart & Background Colours

wonkymeister — Mon, 16 Feb 2015 15:57:24 GMT

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.