Discussion Board for collaboration on QlikView Scripting.
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
do i have to use an expression for each KPI? and add something to the background colour of each expression?
is it possible to specify the colour of each individual block?
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
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.