topic Re: Chart question in QlikView

Chart question

Thu, 23 Jan 2014 16:03:59 GMT

Hi,

I have a bar chart where I want to set the colours to red or greeen. Red if the 'follow up year' is <2014 and Green if >=2014.

Then the same for the month ie; if it's Feb in 2014 I want Jan to be red and the other months green.

Hope that makes sense, look forward to you advice!

Re: Chart question

Thu, 23 Jan 2014 16:07:11 GMT

Hi Sara

use the background colour to set

if (year=2014, red(), green())

same for month but you should better set a variable with your last month-year (feb-2014 under date format 01/02/2014) and compare to $(var)

best regards

Chris

Re: Chart question

Mon, 27 Jan 2014 10:47:41 GMT

I can't seem to be able to change it in the colour tab, does this need to be done in the script??

Re: Chart question

Mon, 27 Jan 2014 10:56:18 GMT

Hi Sara

the background to modify is in tab "Expression"

Result gives something like this

best regards

Chris

Re: Chart question

jonathandienst — Mon, 27 Jan 2014 10:59:08 GMT

On the charts Properties | Expressions tab, click the + sign next to the expression and enter the colour expression in the background colour option.The field Year must have a single possible value for each value of the dimensions.

HTH

Jonathan

Re: Chart question

rustyfishbones — Mon, 27 Jan 2014 11:00:29 GMT

Hi Sara,

you add the IF Statement here

Re: Chart question

Mon, 27 Jan 2014 11:01:26 GMT

Re: Chart question

Anonymous — Mon, 27 Jan 2014 11:01:35 GMT

Following on from Chris's answer, you need to click on the little + next to the expression in the expressions tab, then choose Background Colour

Re: Chart question

amit_saini — Mon, 27 Jan 2014 11:02:01 GMT

Hi Sara

You need to give condition in Background Color option :

Re: Chart question

Mon, 27 Jan 2014 11:12:35 GMT

Finally it's working!!!! However, my 'others' column is red too and I want this grey. Do I need to add another expression??

Thank you.

Re: Chart question

rustyfishbones — Mon, 27 Jan 2014 11:18:08 GMT

Can you share the App?

Re: Chart question

Mon, 27 Jan 2014 12:48:34 GMT

Sara

if you want all others grey but 1 red you set grey color as first color in "Colors" tab and just fix the background color expression (Tab Expression) with a condtion (if (fieldname = value, red())

that's it

best regards

Chris