Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
yddona_lyn
Not applicable

Re: How to make table in qlik sense just 2 colors

was this resolved already?

i converted Omar's solution to this:

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

29 Replies
OmarBenSalem
Not applicable

Re: How to make table in qlik sense just 2 colors

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

Re: How to make table in qlik sense just 2 colors

Where shld I put this line of Code pls ??

Not applicable

Re: How to make table in qlik sense just 2 colors

Sorry, just seeing the last bit of your message.

danansell42
Not applicable

Re: How to make table in qlik sense just 2 colors

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

OmarBenSalem
Not applicable

Re: How to make table in qlik sense just 2 colors

In each column :

Capture.PNG

ivostapchuk
Not applicable

Re: How to make table in qlik sense just 2 colors

In Background color expression

Not applicable

Re: How to make table in qlik sense just 2 colors

Hi Omar,

   look at the result of the code here

its giving me same color on all lines.

OmarBenSalem
Not applicable

Re: How to make table in qlik sense just 2 colors

What's your expression?

Not applicable

Re: How to make table in qlik sense just 2 colors

exactly the same one u sent to me on here.