Solved: Writing first query - Qlik Community

Report Inappropriate Content · ‎2016-12-24

My company just got me the QlikView developer tools for my desktop. Attaching a Teradata source was a snap with my system ODBC.

My question is with the table connector. It either joined way too many fields or set up an entirely stupid connection that I cannot see how to disconnect.

My background is in Access so I am used to dragging the joins myself.

lironbaram · ‎2016-12-25

hi

Qlikview is joining field according to their names ,

so you can go with this approach :

write in the script

Qualify *; - this will add the table name to all the fields

and than write another line

unqualify Key_Field ; -this will leave the key field name as in the source,

and so qlikview will only connect the tables according to this field

View solution in original post

lironbaram · ‎2016-12-25

hi

Qlikview is joining field according to their names ,

so you can go with this approach :

write in the script

Qualify *; - this will add the table name to all the fields

and than write another line

unqualify Key_Field ; -this will leave the key field name as in the source,

and so qlikview will only connect the tables according to this field

vinieme12 · ‎2016-12-25

In Qlikview we have Dynamic Association, any field with the same names from different tables will automatically be associated.

here is a link to downloading the reference manual (search for "Association")

http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.