Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
gzboy008
New Contributor

Struggle for several hours about pivot table's color setting problem

Hi Guys,

Wish you all the best.

Here's comes a big problem to me. Hope anyone can help. Thanks in advance~

1. I can't remove the blank spece from my pivot which leads my pivot color inconsistent,

2. I can't set the line color as pic 2

1.png

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Struggle for several hours about pivot table's color setting problem

Did you see my qvw file attached, there you can see the red lines right? What do you mean works few times? When you come out of Grid mode are they going off?

View solution in original post

13 Replies
vishsaggi
Esteemed Contributor III

Re: Struggle for several hours about pivot table's color setting problem

You need a macro or some other work around to take off those empty spaces. However, you get the red border lines,

Click Ctrl+G, then using Before and After cell color, you can get the red lines. Like here:

Capture.PNG

gzboy008
New Contributor

Re: Struggle for several hours about pivot table's color setting problem

Hi Vishwarath,

Thanks for your reply. Ctrl+G doesn't work. It still change the vertical line.

Would you please attached the file?

Thanks!

Chanty4u
Esteemed Contributor III

Re: Struggle for several hours about pivot table's color setting problem

try to  follow below steps

go to -->View tab--> select design grid

then select you table  right clik custom format cell

there follow below image  you wll get it.custom.PNG

gzboy008
New Contributor

Re: Struggle for several hours about pivot table's color setting problem

Hi Chanty,

It works for straight table but not in pivot table. Is it a bug? I'm using Version 11.20.12577.0 SR8.

gzboy008
New Contributor

Re: Struggle for several hours about pivot table's color setting problem

Due to company's policy, I'm not allow to upload any pic or file into Community. I can only download files.

What I uploaded before is at home.

vishsaggi
Esteemed Contributor III

Re: Struggle for several hours about pivot table's color setting problem

Attached.

Chanty4u
Esteemed Contributor III

Re: Struggle for several hours about pivot table's color setting problem

follow the steps which i have mentioned above then you come to know the result what your are expecting.

gzboy008
New Contributor

Re: Struggle for several hours about pivot table's color setting problem

Hi Chanty,

I always got the vertical border changed as below. I try many time but can't change the horizonal border.

Do you know the reason? Thanks~

1.png

gzboy008
New Contributor

Re: Struggle for several hours about pivot table's color setting problem

Hi Vishwarah,

I always got the vertical border changed as below. I try many times but can't change the horizonal border.

Do you know the reason? Thanks~

1.png