Re: File with multiple tables as source - Qlik Community

Anonymous · ‎2017-02-27

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 · ‎2017-02-27

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 · ‎2017-02-27

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

muthukumar77 · ‎2017-02-27

Hi,

Can you tell clearly what you want?

Muthukumar Pandiyan

ramasaisaksoft · ‎2017-02-27

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 · ‎2017-02-27

Hello,

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