topic Re: Pivot Table hide dimension border in QlikView

Pivot Table hide dimension border

Tue, 29 Apr 2014 08:10:54 GMT

Hello Community,

I am trying to hide the border for second dimension which I am using in Pivot Table.(see screenshot)

I have tried all the following stuff but not meet my expectations:

1) Using Custom format cell

2) Change different style modes.(I need Classic style:- horizontal and vertical borders)

3) Tried unchecking the Vertical Dimension Cell Borders.

Putting a text box over it does solve it, but that is not what I am looking for.

Is there any other way to resolve this.

Thanks,

Angad

Re: Pivot Table hide dimension border

MK_QSL — Tue, 29 Apr 2014 08:30:20 GMT

Kindly upload your sample apps.

Re: Pivot Table hide dimension border

neha_shirsath — Tue, 29 Apr 2014 08:32:44 GMT

Hi,

Try this-

Go to chart properties>Style>Cell Border Transparency> 100%

-Regards,

Neha

Re: Pivot Table hide dimension border

sujeetsingh — Tue, 29 Apr 2014 08:35:27 GMT

Try some tricks like keeping Text box objects etc.

Re: Pivot Table hide dimension border

Tue, 29 Apr 2014 09:20:09 GMT

Hey Neha,

This will make all the borders disappear. I just need that particular dimension border.

Thanks,

Angad

Re: Pivot Table hide dimension border

Tue, 29 Apr 2014 09:21:07 GMT

Hello Sujeet,

That is what I am using write now, but I find this solution very rigid. Was thinking, if there is any other way to acheive this.

Thanks,

Angad

Re: Pivot Table hide dimension border

msteedle — Sat, 03 May 2014 13:57:57 GMT

No, there is not. I know that's not that answer you were looking for, but at least you don't have to keep looking in vain for a solution that doesn't exist.

Re: Pivot Table hide dimension border

SunilChauhan — Sat, 03 May 2014 15:16:17 GMT

Hi Angad,

genrally its not good to show this. as many customer asked to remove that.

so you can take text box and change color to white and Uncheck layout allow /move size

hope this give another insight