Discussion Board for collaboration on QlikView Layout & Visualizations.
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....
Change color accordingly
By using custom format cells we can change top and bottom border colors of cells but not side borders.
it will help you.
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.
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 %`
Inconsistent Column Borders
Solid lines should separate all columns.
Function, Entity, Subfunction, Career Level, Not Rated, Weakness, Development Need, Proficient, Real Strength, Exceptional & Total
Columns separating # and %
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).