topic removing lines from header-- urgent pls help in QlikView

removing lines from header-- urgent pls help

sonikajain — Wed, 09 May 2012 08:49:55 GMT

Hi all,

Please advise on removing the black lines(appearing as 'L' shaped) from header of the pivot table. pic of attached here

Thanks,

Sonika

removing lines from header-- urgent pls help

sonikajain — Wed, 09 May 2012 10:31:38 GMT

the border lines..pls help

removing lines from header-- urgent pls help

Miguel_Angel_Baeyens — Wed, 09 May 2012 11:26:56 GMT

Hi Sonika,

This usually happens when the dimensions or expressions have no label or the space is very limited. Anyway, there are two ways to work that around. The neat one is right clicking on that part of the chart, selecting "Custom Format Cell" from the drop down menu and set the colors and backgrounds to white, transparent, or what you need.

In order to see the "Custom Format Cell" option in the menu you will need to go to the Settings menu, User Preferences, Design tab, and click on "Always Show Design Items"

If this does not work, the not neat at all option is to create an empty text object with the size and colors you need and place one level upper the object (in the Layout tab of the object).

Hope that helps.

Miguel

removing lines from header-- urgent pls help

vipin_mishra479 — Thu, 10 May 2012 09:35:41 GMT

Mr.miguel is not working..

removing lines from header-- urgent pls help

Miguel_Angel_Baeyens — Thu, 10 May 2012 10:34:58 GMT

Which one?

removing lines from header-- urgent pls help

sonikajain — Thu, 17 May 2012 04:40:31 GMT

still not able to remove the line.Pls help

removing lines from header-- urgent pls help

janardhan — Thu, 17 May 2012 04:54:14 GMT

Hi ,

As per my knowledge it is correct or not i dont know pls try like this

when u r loading the excel file dont select embeded labels , that should be none means it will work i think.

Regards

Janardhan