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