color expression

[#1]

Hi,

I've created a pivot table and would like to add some text colour (specifically the Totals).

Can you tell me some colour expressions please?

Alex

[marcus_sommer]

Have a look here: Qlik Sense Color Range Theme Approach

- Marcus

[reddy-s]

Hi Alex,

You can use the background colour expression field or the text colour expression field to achieve this.

use a colour coding expression like this:

if((sum({$<[Selling Department.Date Closed] = {'X'}>}[Current Stock Budget])-sum( {$ <[Posting Date]={"Present"},[WOC Stock Type ID]={1,2,3}, [Selling Department.Date Closed] = {'X'} >}[Stock Value])>0),rgb(146,208,80),rgb(255,0,0))

Thanks,

Sangram.

[#4]

Hello,

you can alspo use in Properties - Visualisation:

[#5]

Can you send me a list of colours please?

e.g.  rgb(146,208,80)

[reddy-s]

Hi Alex,

Use rgb(Red,Green,Blue) : replace the red, green & blue with the values in the table above.

Thanks,

Sangram.

[#7]

Hi Alex,

Qlik has predefined some colour functions that we can use (i.e. the RGB value is Predefined). The colour functions and their respective RGB values are given below.

Color function	RGB value
black ([alpha])	(0,0,0)
blue([alpha])	(0,0,128)
brown([alpha])	(128,128,0)
cyan([alpha])	(0,128,128)
darkgray([alpha])	(128,128,128)
green([alpha])	(0,128,0)
lightblue([alpha])	(0,0,255)
lightcyan([alpha])	(0,255,255)
lightgray([alpha])	(192,192,192)
lightgreen([alpha])	(0,255,0)
lightmagenta([alpha])	(255,0,255)
lightred([alpha])	(255,0,0)
magenta([alpha])	(128,0,128)
red([alpha])	(128,0,0)
white([alpha])	(255,255,255)
yellow([alpha])	(255,255,0)

The alpha value represents full transparency if its value is 0 and represents full opacity if its value is 255.

So you can also define how intense the colour should be.

You will find more information on Qlik Sense help.

Regards,

Rohan

[#8]

Thank you. Great help!

[jagan]

Hi Alex,

Check this link for more colors, you can set your own colors by mixing up Red, Green and Blue values.

Hope this helps you.

RGB Color Codes Chart

Regards,

Jagan.

[reddy-s]

Hi Alex,

You can also make use of this to pick your colours:

Color Picker - ColorPicker.com

Thanks,

Sangram.