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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a single line or double line to a pivot table

HI Everyone,

Does anyone know how to add a line or double line to a pivot table.  I need them for some financial apps.  I know you can underline the text but I want the line to go all the way across the pivot table or at least put a line (border) on the bottom of the cell.

See attached.  thank you so much,

21 Replies
Not applicable
Author

I think I know where the confusion is.  I added a total row (checked partial sum totals) and was able to add the double-line.  All those rows are in the same field and I want to add a double line under the row that says "Controllable Margin Percent" actually just under the percentages, so in the image it would be 46.61% and 45.72%.

line in pivot5.JPG

JonnyPoole
Former Employee
Former Employee

Total sidebar but this looks like some painful cell based formatting that is not ideal in Qlik so..... why not use an Excel based template that uses Qlik as the data source to author such a display ? 

www.vizubi.com/nprinting

NPRINTING offers an excel based report writer to use ALL of excel's cell by cell based formatting features to author a report using a QVW as a data source. Minimal nprinting skills needed. just qlikview skills and MS office skills.

i only wrote this because i've been there AND uses NPRINTING to do what i couldn't do in 2 days in qlik with only 15 mins in nprinting.