topic Re: File with multiple tables as source in QlikView

File with multiple tables as source

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like to know if there is any example of a file with multiple tables as source to see the data-model.

thank you

Peter_Cammaert — Mon, 27 Feb 2017 12:29:21 GMT

QlikView Desktop comes with a series of example documents. I believe they all have multiple internal tables.

For example:

Sales Compass.qvw has a simple data model and you can see how it's built in the LOAD script
Executive Dashboard.qvw has a very complex data model, but LOAD script contains not much more than a BINARY Load.

Good luck,

Peter

Anonymous — Mon, 27 Feb 2017 12:40:22 GMT

I am interested on the loading of multiple tables on script so there are not any circular references.

muthukumar77 — Mon, 27 Feb 2017 13:28:18 GMT

Hi,

Can you tell clearly what you want?

ramasaisaksoft — Mon, 27 Feb 2017 14:12:11 GMT

Then try to create your own data model so that it will practice to you.

if you install SQL /Sql server in your machine then down load default databases North wind,

you can download these databases and create your own data model without synthetic keys and loops

else if you want to see Data model you need to have the Proper License to open qvw.

in qlik demo apps some files have option to open the code/Script also and you can watch table viewer (Ctrl+T)

Anonymous — Mon, 27 Feb 2017 16:06:22 GMT

Hello,

i want to know the best way to load data from 6 differnent tables withouth having circular references