Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@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