Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

color expression

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

9 Replies

Re: color expression

Have a look here: Qlik Sense Color Range Theme Approach

- Marcus

reddys310
Honored Contributor II

Re: color expression

Hi Alex,

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

Capture.PNG

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.

Not applicable

Re: color expression

Hello,

you can alspo use in Properties - Visualisation:

visualisation.JPG

Not applicable

Re: color expression

Can you send me a list of colours please?

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

reddys310
Honored Contributor II

Re: color expression

Hi Alex,

Capture.PNG

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

Thanks,

Sangram.

Not applicable

Re: color expression

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 functionRGB 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

Not applicable

Re: color expression

Thank you. Great help!

MVP
MVP

Re: color expression

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.

reddys310
Honored Contributor II

Re: color expression

Hi Alex,

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

Color Picker - ColorPicker.com

Thanks,

Sangram.