topic Re: chart help in QlikView

chart help

Tue, 08 Sep 2015 15:12:34 GMT

Hi,

2 questions please with a chart (its a straight table).

Please see attached - this is the table as it stands. Can anyone highlight how:

1) Whether we can make individual column headers a different colour? You will see the column 'target 15/16' where we have changed the individual rows but can't see how to do the header.

2) What the expression would be so the colour of the 'average mean score' would change dependent on whether it was a higher or lower than the target. For example as it stands New Homes 'average mean score' would be green as its higher than the 4.8 target (if it was less would want it to be red). I appreciate this is done on the visual cues tab but don't know what expression would be.

Any help would be grately appreciated.

Chris

Re: chart help

Anonymous — Tue, 08 Sep 2015 15:25:37 GMT

1) Goto Menu View and clikc Design Grid

next goto to your table, right mouse click and "custom Format cell"
you can Position any part of your table and define Color etc.

2) under visual clues try

upper Limit: >= avg(value) and define Color, same to other colors

Re: chart help

Wed, 09 Sep 2015 06:25:11 GMT

Hi Rudolf

1) Found design grid and then selected colum header I want to change; however, no option to just chnage the selected. Apply change 'all dimensions' only so as a result all the column headers change colour.

2) Sorry but I dont understnd this. when you say value what figure is this? and defining colour do you mean the RGB, e.g (255,0,0)

Chris

Re: chart help

Anonymous — Wed, 09 Sep 2015 06:34:39 GMT

1) then goto your Dimension, click on sign +, select Background Color and define your Color (with rgb code, but prefeered by variable which contains rgb code)

2) like in Picture, you can define a Color direct or enter a calcualation (rgb code, variable etc,)

Re: chart help

Wed, 09 Sep 2015 06:46:21 GMT

Hi Rudolf,

1) Now working - thank you

2) Your value? is this the number lke 4.7? The number is different for each service area though so the expression would need to be more dynamic than that?..I guess almost an If statement.

Sorry if this comes across really silly.

Chris

Re: chart help

Anonymous — Wed, 09 Sep 2015 06:52:16 GMT

Hi ,

1 .Use custom format cell to color header.

2. To color the data in the expression.

Under text color--> if(Target14/16 > 1,green(),Red())

Re: chart help

Anonymous — Wed, 09 Sep 2015 07:00:28 GMT

what do you want in Point 2

example: you have Dimension SalesPerson and Expression sum(sales);

you want to Highlight when a salesperson sells above average of salesperson

then avg(sales) would do it

-> I have a straight table exactly like that with other Dimension, Expression). I only see those datarows which meets the condition with the defined Color

If this doesnot meet your requirement then you should specify more in Detail wah you want to achieve. Or best, post a small example! I hope this doesnot sound silly,but in my case it works!

Re: chart help

Wed, 09 Sep 2015 07:01:25 GMT

Text colour isn't an option in an expression - only in dimensions tab...?

I've added the expression in visual clues...asumme this one would be used for 'lower' and then flip it for 'Upper'

if([Target 15/16] > 1,green(),Red())

Re: chart help

Wed, 09 Sep 2015 07:07:27 GMT

Hi,

We want the 'average (mean score)' box for each service area to go either green or red depending on the score. So:

- if the average mean score is higher then the 'target' figure we want it to colour green automatically

- if the average mean score is lower then the 'target' figure we want it to colour red automatically

Re: chart help

Anonymous — Wed, 09 Sep 2015 07:21:19 GMT

ID	Budget	Sales

1	99	100
2	250	200
3	350	300
4	250	400
5	500	100
6	1000	600

Look in the above table .data is in red and green colors .Is that you are looking for ?

If that is your requirement Use text color

Re: chart help

Wed, 09 Sep 2015 07:31:56 GMT

Thanks for your help Rudolf and Rgv Rand.

Let see how it goes but looking good.

Re: chart help

Wed, 09 Sep 2015 07:37:10 GMT

Hi,

Quick final question.

if([Target 15/16]<[Average (Mean Score)], Green(),Red())

The expression above works and scores red or green. Is there a way to make it not apply to the total?

There is no overall target so it shouldnt be green or red.

Chris

Re: chart help

Anonymous — Wed, 09 Sep 2015 09:10:44 GMT

I am not sure this will work

But t ry with custom format cell .

Let me Check on it

Thanks