Any way to add a tablename/header row inside a straight or pivot table chart?

[stevelord]

Hi Community, is there a way to add a tablename type header row inside a straight or pivot table above the column headers?

I'd like it to export to excel something like this:

Weekly Payment Report

OfficeName EmployeeCount EarnedMaxPayment

Mercury      500                    12

Venus          123                    0

Earth            3,605                 423

(Please don't suggest bar charts either.   The actual report is hundreds of rows and dozens of columns.)

Trying to help the report be more intuitive per a user request without adding excel steps to what I have to do when I pull it.  Report is exported and reviewed by non-qlikview people before it is sent to an external client who has no qlikview.  I could probably hand them object images and the like, but they like to write notes sometimes or copy/paste on to other things they have or something, so export to excel is the way we go.

Thanks in advance!

[settu_periasamy]

Hi,

if you want the macro, refer the below link..

How to export to Excel include Title Caption?

[stevelord]

Thanks, however I think there's one catch to that.  As far as I know, the Qlikview Management Console won't do scheduled reloads of qvws that include macros.  Apologies for missing that requirement.  Not sure if that has changed.  (I'm pretty sure nprinting has a solution for that, but the pricetag for that additional option is a bit too large to justify for this particular need. )

[settu_periasamy]

Yes Agreed 🙂