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