Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make table in qlik sense just 2 colors

Hi All,

    I need help making my table object lines  to have just 2 colors like the below:

 

Apps

Links

  1. No.

Harp

  1. www.

45657

Logo

  1. www.

56576

Umbrella

  1. www.

55748

Study ops

  1. www.

23243

Shotgun

  1. www.

54647

British

  1. www.

86769

CMPS

  1. www.

34564

 

How can i have such table, with just 2 colors?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

was this resolved already?

i converted Omar's solution to this:

if(mod(RowNo(Total),2)=1,Green(),Red())

View solution in original post

29 Replies
OmarBenSalem

try this in the background colours of your dimensions and measure:

if(mod(RowNo(),2)=1,Green(),Red())

change the colours as you want

result:

Capture.PNG

Not applicable
Author

Where shld I put this line of Code pls ??

Not applicable
Author

Sorry, just seeing the last bit of your message.

danansell42
Creator III
Creator III

It goes in the 'background color expression' in each column

OmarBenSalem

In each column :

Capture.PNG

Anonymous
Not applicable
Author

In Background color expression

Not applicable
Author

Hi Omar,

   look at the result of the code here

its giving me same color on all lines.

OmarBenSalem

What's your expression?

Not applicable
Author

exactly the same one u sent to me on here.