Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart help

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

12 Replies
Not applicable
Author

Thanks for your help Rudolf and Rgv Rand.

Let see how it goes but looking good.

Not applicable
Author

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

Anonymous
Not applicable
Author

Hi

I am not sure this will work

But t ry with custom format cell .

Let me Check on it

Thanks