topic Re: Pivot table horizontal dimension border in QlikView

Pivot table horizontal dimension border

Thu, 17 Jan 2013 13:31:22 GMT

Hi Qlikview community,

How can add a border on a straight table horizontal dimension ?? I want to tranform my table prom picture 1 to picture 2.

Thanks in advance.

Re: Straight table horizontal dimension border

Thu, 17 Jan 2013 13:39:36 GMT

Hi,

If I am not missing something, it seems you are usng a pivot table.

In a pivot table, just click on the column header and drag-to-move or reposition when the blue pointer comes up. Ensure that the 'Allow Pivoting' option is enabled under the Presentation tab.

Hope that helps.

Regards,

-Khaled.

Re: Straight table horizontal dimension border

Thu, 17 Jan 2013 13:45:56 GMT

Yes you are right its a pivot not a straight table. I have tried to do what you mentioned above but the problem is i can not get the exact same format as I have in pic 2. I want the year month to be on the top of product not on the side.

Re: Straight table horizontal dimension border

Thu, 17 Jan 2013 13:54:57 GMT

Could you please post a sample?

Re: Straight table horizontal dimension border

Thu, 17 Jan 2013 14:19:08 GMT

As I posted above I want to go from picture 1 to Picture 2 and draging the dimention to the top does not do the trick. Any other aspects of the that I have not considered???

Re: Straight table horizontal dimension border

Mon, 21 Jan 2013 10:16:05 GMT

Any idea anyone???? Its not a major deal but i would really like to know if it can be done or its just bugged.

Re: Pivot table horizontal dimension border

Anonymous — Wed, 29 Oct 2014 12:08:18 GMT

Press Ctrl+G ,Right click-Select custom format cell and you can cusomize border for one cell and apply it to all dim as well as expression.