Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to give a color to data in column data ?

Hi all,

i have a pivot and straight tables . i want indicate color to data for easy identifications.

example

   name

-------------

     a          = some color

     b

     c          = some color

     d

     a         =some color

     c         = some color

i want give a color for easy identification.

9 Replies
varshavig12
Specialist
Specialist

Text Color

Chanty4u
MVP
MVP

custom format cell?

Anonymous
Not applicable
Author

Hi,

Highlighting every row in each different color, might not look good in my opinion.

It will be like distracting.

You can try as  per ur requirement and  as below,

bgcolor.PNG

U can change the style of the table by selecting styles (Current Styles)

Else,

you can change text color or background color by expression

bgcolor2.PNG

Else in dimension similar to expression

Else in Visual Cues, you can change the text and background color by setting upper and lower values

bgcolor3.PNG

Thanks

Kishore

varshavig12
Specialist
Specialist

=if(Fieldname='a',red(),if(Fieldname='c',blue()))

susovan
Partner - Specialist
Partner - Specialist

Hi,

Try this,

6.JPG

Warm Regards,
Susovan
vikasmahajan

try this

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
NareshGuntur
Partner - Specialist
Partner - Specialist

tamilarasu
Champion
Champion

Hi,

You can use below expression.

=Pick(Match(Name,'a','b','c','d'),Red(),Green(),Yellow(),Blue())

You can use this in two places based on your requirment. 

Dimensions:

Dimension.PNG

Expressions:

Expression.PNG

Not applicable
Author

thank you sir