Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jayabedin
Contributor III
Contributor III

Extra Cell border in Pivot table

Hi,

I am using qlikview 12.10. We have a Pivot table with 2 dimension and a measure. The table is including one extra cell border. How can I avoid this. I hope this is not too difficult. But could not find a way.

Please find picture for consideration.

Capture.JPG

Regards

Jay

9 Replies
Anil_Babu_Samineni

You said, You used 2 Dimensions but i am seeing only 2 Cell borders. Can you point out which you are telling about?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
inoruoya
Partner - Contributor III
Partner - Contributor III

try this

test2.PNG

jayabedin
Contributor III
Contributor III
Author

Activity and Months are my dimension. Months been drag to create cross tab. Now the | added in.

I tried Style and transparency. But can't get rid of the | after activity header.

inoruoya
Partner - Contributor III
Partner - Contributor III

I think you can't get rid or remove of the | (Month field) after activity header

jayabedin
Contributor III
Contributor III
Author

Thanks Anya.

Hope someone find a work around. It does not look good in the dashboard.

Jay

Anil_Babu_Samineni

Which one you want to remove from below image? Can you attach to test

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jayabedin
Contributor III
Contributor III
Author

The first one from the left after activity.

Anil_Babu_Samineni

No way, But i heard from Manish Kachhia we can do using Macro. Let him back. But for sure, He is busy with work for last 2 months

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jayabedin
Contributor III
Contributor III
Author

Thanks Anil.

At least I can give up now for the time being. Can't believe it though. This does not look good.

Hope Manish Kachhia will bring some lights for us one day.

Regards

Jay