Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlikie
Creator
Creator

Report with tables from different documents

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

8 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

newqlikie
Creator
Creator
Author

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

IAMDV
Master II
Master II

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

IAMDV
Master II
Master II

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

jagan
Partner - Champion III
Partner - Champion III

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.

newqlikie
Creator
Creator
Author

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

IAMDV
Master II
Master II

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

newqlikie
Creator
Creator
Author

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