topic Multiple custom SQL connection to Qlikview in QlikView

Multiple custom SQL connection to Qlikview

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

I am very new to Qlikview and i have been using tableau till now. I want to make a dashboard which has multiple custom SQL queries. For ex:

Product table+price table as one connection,

Product table+review table as one connection,

Product table+specification table and so on...

These tables will be updated with new data everyday. When i make these connections in Qlikview, it shows as sync and the system is hanging. I think its trying to club all the data connections together. How do i avoid this and keep them as individual data connections?

Re: Multiple custom SQL connection to Qlikview

Anonymous — Mon, 19 Feb 2018 17:59:46 GMT

Hello Avinash.

I think you have multiple fields with the same name in different tables and thats why Qlikview makes the synthetic key.

Hope this links clarify it a bit for you.

Synthetic Keys

Best Practices in Data Modeling.pdf

If not please upload your QVW to be able to assist you better.

Regards,

Josefina

Re: Multiple custom SQL connection to Qlikview

shilpan — Mon, 19 Feb 2018 20:54:45 GMT

Also make sure that there aren't any Cartesian joins among these tables

Re: Multiple custom SQL connection to Qlikview

vishsaggi — Mon, 19 Feb 2018 21:18:29 GMT

Use Qualify and Unqualify keywords.

Connection 1;

Qualify *;

Unqualify KeyIDField;

Table1:

LOAD *

FROM yoursourceTable;

Connection 2;

Qualify *;

Unqualify KeyIDField;

Table2:

LOAD *

FROM yoursourceTable;

Connection 3;

Qualify *;

Unqualify KeyIDField;

Table3:

LOAD *

FROM yoursourceTable;

If this does not help can you paste your actual script you are trying to run.