Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

techvarun
Valued Contributor II

Display alternate lines in different color

Hi All,

I have a straight table with multiple expressions. now i want to show the lines between expressions in two different color black and grey.

Tried many workarounds but nothing worked....

Any suggestions 

Regards

Varun

5 Replies
Highlighted
MVP
MVP

Re: Display alternate lines in different color

Like this?

Change color accordingly

Highlighted
mdmukramali
Valued Contributor III

Re: Display alternate lines in different color

Dear ,

By using custom format cells we can change top and bottom border colors of cells but not side borders.

PFA,

it will help you.

Thanks,

Mukram.

Highlighted
aveeeeeee7en
Valued Contributor III

Re: Display alternate lines in different color

Go to your expression, click on plus sign. There you'll see Background color. Open the Expression by double clicking on it and Use below expression in Background Color:

If(Mod(RowNo(TOTAL), 2) = 0, RGB(0,0,0),RGB(128,128,128))

It will work for you.

Regards

Aviral Nag

Highlighted
techvarun
Valued Contributor II

Re: Display alternate lines in different color

Thanks you all for ur super fast reply.

                     My problem is want to change the line color and not the row colorPicture1.png

I want black line after the expressions starts with # and i want grey line after the expressions starts with %`

Thanks Again

Inconsistent Column Borders

Solid lines should separate all columns.

Black:

Function, Entity, Subfunction, Career Level, Not Rated, Weakness, Development Need, Proficient, Real Strength, Exceptional & Total

Grey:

Columns separating # and %

Highlighted
c_gilbert
Contributor II

Re: Display alternate lines in different color

I don't think this is possible.

The workaround which we use, is overlaying the table with line objects (which have transparent backgrounds, no shadow or border).