we have the same requirement here, only we need the reports in pdf_format - to be printed, sent by email or just saved for further processing.
=> With pdf, QlikView is okay. The structure of the reports can be created in a QlikView_app and it can be automatically generated exactly like that, as often as you want.
<=> I think with Excel, that is a bit more complicated. There are tools that can automatically export QlikView data to Excel, but then you'd end up with a brand-new Excel file every time. When it comes to some "excel-internal" formatting, that will be a bit tricky. I have no experience there, I don't know if some tool enables you to tell ´QlikView to use a kind of stylesheet to apply the formatting.
=> You might be able to use formulas in a pre-formatted Excel file to just copy the contents from such a report, or
use some VBA to do the formatting.
You are correct that QlikView itself is not a great report writer. It's OK but report writing is not one of it's strengths. QlikView focuses more on the ability to drill through and analyse the data.
There are a number of products which bolt onto QlikView to provide superior reporting functionality - NPrinting, QV Report and CIA to name a few.
I use NPrinting as you can build templates in Excel, Word, Powerpoint, PixelPerfectPDF or HTML. Into these templates you can place charts, tables and text from multiple QlikView apps at the same time.
The scheduler allows you to launch several different tasks:
You can reload/refresh your QlikView data and populate your templates with fresh information.
You can also automatically import a list of users that you wish to send the reports to.
Macros can be triggered.
Filters functionality allows you to take different cuts of your data to build output for many different users.
The output can be sent as part of a schedule to a folder, Google Drive or as an email attachment.
Can you please explain this part?
"The scheduler allows you to launch several different tasks:
You can reload/refresh your QlikView data"
Is this done through EDX? If so can you please explain how to establish a connection between the NPrinting scheduler with QV's Publisher. This can be useful in reloading fresh data to generate latest reports.
NPrinting has it's own scheduling system that you can use. Not only can it run NPrinting tasks but it can run a QlikView reload too.
If you have Publisher you can create an NPrinting trigger file. To plagiarize something Steve Dark wrote recently on Publisher:
You could use Publisher to fire an NPrinting request simply by scheduling an External Task in Publisher to fire a batch file that creates the .request file for NPrinting. You could also create the .request file from a QlikView reload by loading the required XML into a table in QlikView and using a STORE command to a .request file. Note that the column name of the table would need to be the first line of the XML (as you can not suppress the column header with the STORE statement).