Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table horizontal dimension border

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.

6 Replies
Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

Could you please post a sample?

Not applicable
Author

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???

Not applicable
Author

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

Anonymous
Not applicable
Author

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.