topic Table Links in QlikView

Table Links

Tue, 08 Nov 2011 10:15:05 GMT

Hi all

I am currently replicating a very complicated table structure into Qlikview which when all included creates over 29 synthetic keys and a ridiculous amount of links between tables that i do not need and will take me days to sort out!

Is there a way of disabling automatic links so that, much in the way Microsoft Access works, i am able to manually create links and then sort out the other fields out accordingly?

Any advice is much appreciated!

Regards,

Steven Prentice

Table Links

Tue, 08 Nov 2011 10:27:07 GMT

Hi,

try to use

QUALIFY *;

at the beginning of your load script - it takes the tablename and puts it in front of the fieldname (eg testtable.testfield), so you can avoid tables that share the same fieldnames to be linked automatically.

Regards,

Eva

Re: Table Links

Sokkorn — Tue, 08 Nov 2011 10:30:51 GMT

Hi,

Try this scenario

unqualify *;
select * from tab1;
select * from tab2;
select * from tab3;

Regards,

Sokkorn

Table Links

Anonymous — Tue, 08 Nov 2011 11:04:58 GMT

http://michaelellerbeck.com/2008/08/22/qlikview-synthetic-keys/