topic Re: Load more than one table from the save QVD file in QlikView

Load more than one table from the save QVD file

anscelmo — Mon, 21 Aug 2023 18:44:04 GMT

Hi,

I have only one QVD file.

How can I load more than 1 table 2 times from the same QVD file?

for example:

--table 1

Load "ID", "Person Name", "Country"

From myQVDFile.qvd (qvd);

--table 2

Load "Country", count(*) as "Tot Reg"

From myQVDFILE.qvd (qvd) // the same QVD file used in table 1

Group by "Country";

And how can I set a custom name to each table?

Thanks

Or — Mon, 21 Aug 2023 18:57:06 GMT

At the risk of getting in trouble with Nike - just do it. There's no issue here and your version will work.

Naming a table internally is done by using e.g.

Table1:

Load SomeField From SomeTable;

Table2:

Load SomeField2 From SomeOtherTable;

anat — Thu, 24 Aug 2023 12:14:00 GMT

load the data from qvd then use resident load for other calculations