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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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,