Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
is it possible to create a QlikView-report with tables, diagramms, etc. from different documents?
For example:
Dokument1 contains the turnover from suppliers
Dokument2 contains all reklamations from suppliers
Dokument3 contains ???
I do not have a chance to bring out all charts/tables,... in one document. That would be to confusing.
Is it possible to get the table s concerning the turnover and all reklamations in one report?
If it works, this is going to be our evaluation of a supplier.
I really appreciate your help.
Regards,
NewQlikie
Hi,
It is possible to generate a Report using from different files. You can load data from different documents by using
LOAD statement.
Example:
LOAD
*
FROM [Document1.xls]
(biff, embedded labels, table is Sheet1$)
Like this you can load data from n number of documents into qlikview reports.
Regards,
Jagan.
Hi,
thanks Jagan for your reply.
What I mean with documents are the "qlikview.qvw" documents.
So what I like to add in a report are the ready designed tables, charts, ... from a various of existing qlikview documents.
Regards,
NewQlikie
Hi NewQlikie,
Sorry, I am not very clear with your question. If you are looking to Load data from disparate sources then yes it is possible. You can use the wizard based approach or can you also use the Edit Script window to get data from different sources. You can get data from Tables, Other QV files, Web Files, Inline Table, Using ODBC connection and OLE DB connections.
Please refer to QV demos here. Or if you have specific question on particular dataset then please explain in detail and I'd recommend you to post the sample data.
Good luck.
Cheers - DV
If you want to load existing QV document then you use Binary Load. Or click on Edit Module and select QlikView File button if you are using version 9. Binary Load statement is created at the top of the Scripting window. And you can have only one Binary Load per document.
Cheers - DV
Hi,
As DV said it is not possible to load more than one QVW file using Binary Load. Instead what you can do is load each table used in QVWs to QVDs and load those QVDs in new Qlikview document.
Regards,
Jagan.
Hi,
thanks for your answers.
Do I understand you right.
I take the example of the QlikView-demo-qvw's.
1. Document: Facebook friend analyser
2. Document: Alternate States - Brushing Demo
Now I am going generate a report in Document 2 with charts from the same document.
I am not able to add in that report also charts from document 1, right?
The only thing I could do is creating a qvd-file in document 1 to load the data from document 1 into document 2.
What is about the "table viewer" and the "logic operations"?
Afterwards, if I do not have problems with "logic operations", I can copy the the charts from document 1 into document 2 and can use them in te repoprt.
Is that what you mean?
Regards
NewQlikie
Hi Again,
Using binary load you can only import the data model and it does not get the underlying objects. If you wanted to get other objects then you need to export the document layout / sheet layout. This exports the objects in XML format and then you can import these XML files into Document2. Alternatively if its just one object then you can copy & paste the object from Document1 and change the properties.
Hope this helps!
Cheers - DV
Hi DV,
I do not need the "binary load". So the other examples from you look like a good solution for a "one time report".
What if I need that report almost daily? The users, which need the report, only have acces to the documents with the "IE PlugIn".
That seems to be very complicated?
I think, we keep the solution, that the users have to open all relevant QV-documnts, and print the needed report separately.
Is there not any solution, where I can mach reports? Maybe an external solution like "NPrinting", ... ?
Regards
NewQlikie