We have to generate lots of regular reports in Excel format and sending to users by email accordingly to schedule like weekly, monthly and yearly. Some of the reports have a bit formatting requirement.
We prefer QlikView rather than Cognos because we don't want to maintain data warehouse. We just wonder if QlikVIew could be able to generate regular reports like Cognos. (We heard that QlikView is not good at regular reporting even with the help of NPrinting).
Please kindly share your experience in using QlikView. Thanks!
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.
Please can you close your post as answered by clicking on the Correct and Helpful buttons. This will indicate to others that the replies were useful to you and make sure you don't continue getting responses months and months from now.
"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).