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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to give different 2 custom colors for stright table rows ?

Hi All

how to get table like below

Note:  I have gone through style tab  but I want to specify custom color as I like.

I tried with custom format cell but I got only for one expression if I add another expression it is giving only one color for all the entire column.

Please guide me on this

Thanks

John

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

I think you could try looking at setting the background colour for the expression and using RowNo() and a function to return your colours. You probably want to use ARGB() to return colours that work better than my picks;

highlighting_alternate_rows.JPG

You would need to set this for every expression (& dimension I guess).

View solution in original post

2 Replies
chrismarlow
Specialist II
Specialist II

I think you could try looking at setting the background colour for the expression and using RowNo() and a function to return your colours. You probably want to use ARGB() to return colours that work better than my picks;

highlighting_alternate_rows.JPG

You would need to set this for every expression (& dimension I guess).

ecolomer
Master II
Master II

You can use STILE ACTUAL in label STILE  or  use background color with a formula colour depending of RowNo

p02.png