topic Delete empty dimension row in pivot table in QlikView

Delete empty dimension row in pivot table

felcar2013 — Thu, 28 Feb 2013 20:04:32 GMT

this is a pivot table. I do not use dimensions and need to delete the "dimension" row, which is in grey, i takes space and i do not need it. Do you know if this is possible?

thanks

Re: Delete empty dimension row in pivot table

Thu, 28 Feb 2013 20:12:51 GMT

I'm not sure qv provides this option. If you use a straight table, you do have the optoin to suppress the header row in the presentation tab.

Re: Delete empty dimension row in pivot table

Gysbert_Wassenaar — Thu, 28 Feb 2013 20:13:59 GMT

Use a straight table instead. Add your expressions, select the option No Totals and on the Presentation tab check the option Horizontal. If you've enabled Always Show Design Menu Items on the Design tab of the User Properties window you can right click the cells with the expression labels and choose Custom Format Cell to change the formatting of those cells.

Re: Delete empty dimension row in pivot table

felcar2013 — Fri, 01 Mar 2013 08:23:29 GMT

thanks a lot , perfect!