topic Re: Pivot table column borders in QlikView

Pivot table column borders

Anonymous — Wed, 22 Jun 2016 16:04:56 GMT

Withing a pivot table, under custom format cells I can find a way to format the horizontal line before and after cells but not the vertical lines.

Does anyone know a way to do that for one column only?

Thanks

Re: Pivot table column borders

m_woolf — Wed, 22 Jun 2016 16:28:05 GMT

Make sure the Design Grid is turned on.

Then right-click the column and select Custom Format Cell

Re: Pivot table column borders

Anonymous — Wed, 22 Jun 2016 16:38:50 GMT

I can get that far but how do I format the vertical lines there is only the option to format the row lines

Re: Pivot table column borders

trdandamudi — Wed, 22 Jun 2016 17:30:53 GMT

In chart properties, take a look at the tab "Visual Cues" and see if that helps. Here you can select the column you want and you can set Bold, Italc or Underline.

Is this what you are looking for,,?

Re: Pivot table column borders

Anonymous — Wed, 22 Jun 2016 17:36:32 GMT

I am trying to format the border for the column so it appears like this:

Re: Pivot table column borders

Wed, 22 Jun 2016 18:32:20 GMT

Hi Todd

I sugest you to change the background color of this column. Make a discret color change and you will get a similar efect (as I can see in your example). To do this (sorry me if you already know): right-click the table, choose Properties and in the Dimension (or Expression) tab, expand the [+] signal of the dimension (or expression) and change the BackgroundColor with RGB() function.

Let me know your decision, good luck!

Marcello

Re: Pivot table column borders

trdandamudi — Wed, 22 Jun 2016 18:45:44 GMT

Ok.. There is no option for Straight and Pivot table to format the columns.