topic frame around a pivot table in QlikView

frame around a pivot table

Tue, 01 Nov 2011 09:46:41 GMT

hello all,

i hope somebody can help me.

i just made the attached pivot diagramm (see attachment)

i am searching for the QV function to get a frame around the dimension "month" like in the attached picture shown.

i will be thankful for any help.

so long

marti

frame around a pivot table

Tue, 01 Nov 2011 10:56:01 GMT

To do custom formatting, enable designer grid (CTRL+G). Now if you right click the table you can see an option "Custom Format Cell". You can get custom borders/shading etc here, which is selfexplanatory.

Kiran.

frame around a pivot table

Tue, 01 Nov 2011 16:36:46 GMT

as I hit the CTRL+G the designer grid did appear,

but I didn't find the "custom format cell" option.

frame around a pivot table

Tue, 01 Nov 2011 16:43:28 GMT

CTRL+G is to toggle designer grid. Once its active you can see grid on the sheets.

I can get this and I use QV 10 SR3. But make sure you right click on the pivot table.

Kiran.