topic Re: Display alternate lines in different color in QlikView

Display alternate lines in different color

techvarun — Tue, 22 Jul 2014 11:10:27 GMT

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

Re: Display alternate lines in different color

MK_QSL — Tue, 22 Jul 2014 11:37:58 GMT

Like this?

Change color accordingly

Re: Display alternate lines in different color

mdmukramali — Tue, 22 Jul 2014 11:43:29 GMT

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.

Re: Display alternate lines in different color

aveeeeeee7en — Tue, 22 Jul 2014 11:52:17 GMT

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

Re: Display alternate lines in different color

techvarun — Tue, 22 Jul 2014 12:10:40 GMT

Thanks you all for ur super fast reply.

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

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 %

Re: Display alternate lines in different color

c_gilbert — Tue, 22 Jul 2014 14:50:46 GMT

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).