Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in cell space between headers of a pivot table

Error1.png@

Hi all

I have faced very strange situation in pivot table regarding borders between the headers of pivot table . In the above picture i dont from where that black colored line beside  NO.Of Days(rounded in red) Header has came . Please help me out to remove that .

7 Replies
senpradip007
Specialist III
Specialist III

Upload your app.

jyothish8807
Master II
Master II

This is strange. Can you upload your app? Are you giving a custom label name? If no, then give one.

Regards

KC

Best Regards,
KC
Anonymous
Not applicable
Author

yeah !!! i used custom format cell for labelling the headers..

aveeeeeee7en
Specialist III
Specialist III

Hi
This is a not a strange behavior. This is a feature in Pivot Table. You can move the position of column anywhere and plot the result according to it.

See the below snapshots:

1) Hold the Column Header:
Hold the Column Header.png
2) Move the Cursor to the Right Side:
Move the Cursor to Right.png
3) Move the Cursor to the Top Right Hand Side:
Move the Cursor to Top Right above the Expression Column.png
4) Blank Column:
Blank Space.png
5) Go to Custom Format Cell & Do the Changes:
Custom Format Cell. Do the Changes.png
Hope that helps.

Regards
Av7eN
Not applicable
Author

Hi,

you will go to pivot table properties then go to Presentation tab.There are showing "Wrap header text and wrap cell text". check these height.

avinashelite

Hi,

This not a strange , Pivot table is designed like that only, we cannot avoid that , play with the background color and view with the IE plugin .with IE plugin I don't think you will face this issue.

Anonymous
Not applicable
Author

i tried but i couldn't overcome it