Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look here: Qlik Sense Color Range Theme Approach
- Marcus
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.
Hello,
you can alspo use in Properties - Visualisation:
Can you send me a list of colours please?
e.g. rgb(146,208,80)
Hi Alex,
Use rgb(Red,Green,Blue) : replace the red, green & blue with the values in the table above.
Thanks,
Sangram.
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
Thank you. Great help!
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.
Regards,
Jagan.
Hi Alex,
You can also make use of this to pick your colours:
Color Picker - ColorPicker.com
Thanks,
Sangram.