topic Re: Vertical lines in the table/pivottable in QlikView

Vertical lines in the table/pivottable

Thu, 02 May 2013 13:26:44 GMT

Hello,

I can't find where I can add vertiacal line to the column, like this:

Re: Vertical lines in the table/pivottable

Gysbert_Wassenaar — Thu, 02 May 2013 13:31:21 GMT

That's because you can't. There's no such option for straight/pivot table objects. The best you can do is use a text object, resize it so it looks like a vertical line and place it on top of the table.

Re: Vertical lines in the table/pivottable

Fri, 03 May 2013 18:41:01 GMT

You can try this (I've never done this with a pivot table but it works for straight tables) -

Go to the View menu and choose Design Grid

Then, on the chart you want to change, right-click on the number or a cell where you want to add a vertical line, from the menu that appears choose Custom Format Cell.

A Custom Format Cell window will appear that allows you to change cell borders and text attributes for individual cells or rows or columns. Make the change you want and click OK.

If that looks good then go back to the View menu and turn off Design Grid.

Re: Vertical lines in the table/pivottable

alexpanjhc — Fri, 03 May 2013 20:04:01 GMT

I have a simple solution though it is not exactly what you will have but very close.

You can create a expression in the defination part , fill =' '

and then in the backgroud color and text color use =black()

adjust the width of that epression in your straight table.

You should be able to have a line like that.

Hope that helps!