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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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