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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Mastering Change Data Capture: Read Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
bonaiti
Contributor II
Contributor II
‎2010-03-05 08:49 AM

Background colour

Hello. is it possible to calculated a background colour in a gant chart?

For exemple i want to color RED the background for the hour between 12.30 and 14:00.

Thank You

Preview file
1557 KB
516 Views
0 Likes
1 Reply
Not applicable
‎2010-03-05 12:50 PM

Yes, that is possible.

In the sample image you can see Base Color -> Calculated. There you could add color ranges using IF-statements, the Class() statement (creates ranges) or use the Colormix Wizard (perhaps as a starting point). There are probably more options.

Sample of an IF-Statement: IF(Hour>a AND Hour<b, RGB(255,0,0), IF(Hour>=b AND Hour<c, RGB(255,10,0), IF( ...

The ColorMix Wizard can be started like this: open the edit window for the calculated color (button with points in the field when you select the field). Go into menu File and you will see the option Colormix Wizard.

341 Views
0 Likes