topic Re: How to make vertical separator for colums in straight tabel? in QlikView

How to make vertical separator for colums in straight tabel?

retko1985 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

somehow I did a separator, but now I forgot how

Can somebody remind me, how this is done?

Thank you.

Re: How to make vertical separator for colums in straight tabel?

devarasu07 — Fri, 22 Dec 2017 09:46:23 GMT

Hi,

Try can try two ways,

method 1: simply adding empty column with background color as black

refer below is method 1 output.

Method 2: by using Design Grid - custom format border option.

Go to menu -->clik on View menu and choose Design Grid (or short to open grid mode press ctrl+G)

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.

Thanks,

Deva

Re: How to make vertical separator for colums in straight tabel?

asgardd2 — Fri, 22 Dec 2017 15:33:46 GMT

Hello!

To resize empty column you can use macro:

Sub changeSize
set chart = ActiveDocument.GetSheetObject("CH03")
set p = chart.GetProperties

set expr = p.Expressions.Item(1).Item(0).Data.ExpressionVisual

expr.ColWidth = 10 'size

chart.SetProperties p

end sub