Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
M_Matt
Contributor
Contributor

Qlik Pivot Table - Cell Borders

Facing the unenviable task of replicating an excel based stock sheet, one of the 2 remaining criticisms I am currently facing is the  cell bordering within a basic Qlik Pivot table. Despite there being a yellow column denoting the first column of each Stock Date the team are adamant they cannot do without a bold black border as shown in the screenshot below. Stock Sheet Borders.png

I have applied several CSS based customisations already, but whilst I've been able to change the look and feel of the column and row headers I've not been able to affect any change to the cell attributes...if it is even possible.

I have tried using several 3rd Party Pivot extensions, but some of these lose other functionality that I've already worked up.

My last resort would be to add a new "empty" column as the first column of each and colour black using the background colour expression. On this basis...is there any way of limiting the column width of just the first column of each Stock Date?

Conversely, does anyone have any other suggestions that do not require any fundamental/substantial reconfiguring of the Pivot Table?

Many thanks in advance,

Matt

Labels (3)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

@M_Matt , have you tried Vizlib (Vizlib pivottables) I got a case where the result was exactly as you have show (with the screenshot). 

https://community.vizlib.com/support/solutions/articles/35000127357-vizlib-pivot-table-introduction