Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajitha1
Contributor III
Contributor III

How to do color coding in qlik sense

How to do color coding for feb month in gray color

Rajitha1_0-1663928612782.png

 

Labels (1)
2 Solutions

Accepted Solutions
Ray_Strother
Support
Support

Hello,

Perhaps these link will assist you :
1. Color by expression

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expres...



2. Coloring visualizations using expressions - Qlik Sense

https://www.youtube.com/watch?v=u9Z1_QRTG04

View solution in original post

SerhanKaraer
Creator III
Creator III

Hello Rajitha,

Considering your snapshot as the script below in a simplistic way:

LOAD * INLINE [
Month, Dim, Value
Jan, 1, 0.07
Jan, 2, 0.08
Feb, 1, 0.1
Feb, 2, 0.1
Mar, 1, 0.08
Mar, 2, 0.1
];

You must set color to "By expression".

SerhanKaraer_0-1663950245014.png

Then set your expression as below:

if(Month='Feb',hsl(0,0,0.7),if(Dim=1,rgb(0,101,128),rgb(135,32,93)))

 Regards,

View solution in original post

2 Replies
Ray_Strother
Support
Support

Hello,

Perhaps these link will assist you :
1. Color by expression

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Colors/color-by-expres...



2. Coloring visualizations using expressions - Qlik Sense

https://www.youtube.com/watch?v=u9Z1_QRTG04
SerhanKaraer
Creator III
Creator III

Hello Rajitha,

Considering your snapshot as the script below in a simplistic way:

LOAD * INLINE [
Month, Dim, Value
Jan, 1, 0.07
Jan, 2, 0.08
Feb, 1, 0.1
Feb, 2, 0.1
Mar, 1, 0.08
Mar, 2, 0.1
];

You must set color to "By expression".

SerhanKaraer_0-1663950245014.png

Then set your expression as below:

if(Month='Feb',hsl(0,0,0.7),if(Dim=1,rgb(0,101,128),rgb(135,32,93)))

 Regards,