Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a qvw file that contains field values. I want to use this file as an input to another qlikview appliaction and create a sample report /dashboard.
Please let me know the steps for the same.
Hi,
You can indeed load all the fields (not variables nor objects, only tables and fields as seen in the Table Viewer using Ctrl + T) into another QlikView document. It is called Binary Load.
Go to the Script Editor, and on the bottom part click the QlikView File button. Select the QVW file where the data is and click Open. You will see that the first line in the first tab looks now like
Binary
;
Make sure this is your first line in all your script, otherwise, it will not work.
Now reload and all the data model you created in "File.qvw" will be loaded into your new file.
Hope that helps.
Miguel
Hi Miguel,
I've uploaded with the mentioned steps.
Can we code in the edit script for creating a report? or can it be created only from Reports->Document Reports?
Hi,
QlikView Reports are a different thing than the QVW file itself. You can have a QVW to show several charts and objects and show them or not in a Report (a piece of paper with some of the document charts in it). Can you please elaborate on your actual requirements, where are you now and where do you want to get?
Regards,
Miguel
Hi,
I'm able to load the entire data from qvw file with
Binary
I've created a table-box and added the entire data into that.
Now I want to create a report with this data. I tried creating it with
Reports->Document Reports and it is working fine. This entire process has to be automated
ie, getting one qvw as an input to another qlikview application and creating reports/dashboards from the data. I want to know whether there are any commands that can be incorporated into Edit Script for creating a report.
Thanks,
Vasudha
Hi Vasudha,
What you do when you build a report using the Reports menu is just create a new sheet with all the objects you want from you already existing document sheets. This objects (charts, table boxes) will be populated with the information coming from you data sources, in this case, another QVW file. So whenever you reload the latter, the report information will be updated. What you cannot do is to automatically print a report within the script, since the objects only "exist" once the loading script has ended successfully.
If you have Publisher, you can print PDF reports or even creating new reduced QVW files after reloading. If you don't have publisher, you will have to schedule the reload tasks, which will populate the charts, then use a button with an action to print that report. You can try a OnOpen trigger (Settings menu, Document Properties, Print, Print Report and the Report ID). You can try that as well using a OnPostReload trigger, but this might not work because of macro limitations when used in a client - server environment.
Hope that helps.
Miguel