Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Methods to break association


Hi All,

What are the methods to break association other than

Rename

Alter states ???

Regards,

Prajna

7 Replies
Highlighted
Creator III
Creator III

Qualify fields.

Highlighted
Not applicable

how? Can u elaborate?

Regards,

Prajna

Highlighted
Champion
Champion

Hi Prajna,

that's just a command - QUALIFY and UNQUALIFY (look it up in the help file).

Take care, though - we worked with those and ended up with ever-growing fieldnames (like Table1.Table1.Table1.Table1.Field1) - can happen when you have incremental LOADs.

There are other methods, that would depend on your scenario, renaming is the most basic one.

Best regards,

DataNibbler

Highlighted
Not applicable

Yes as suggested by Kourosh add the following to the top of your script:

qualify *;

This adds the table name to all field names (e.g. tablename.fieldname) making all fields unique.

You could then unqualify certain fields if you did want associations, e.g.:

qualify *;

unqualify TransactionId, ProductId;

However please note that QlikView expects an associated data model and may refuse to work and display a warning if there are too many data islands (tables with no associations). That was the case in older versions of QlikView at least.

Highlighted
Creator III
Creator III

Qualify will prefix the table name to a field. e.g.

A:

Load Field1,

     Field2

Resident Table;

Field1 is the field name.

In the example:

Qualify Field1;

A:

Load Field1,

     Field2

Resident Table;

A.Field1 is the field name. Field2 is still Field2.

You can also Qualify *; And you can Unqualify if you want to remove it.

QlikView will associate field names that are the same, you can't override that behaviour.

Highlighted
Creator III
Creator III

Association is resolved once the script is complete, qualification once the statement is complete. So be careful with preceding loads or concatenation when using this.

Highlighted

Prajna

You can mark one of the tables as "loosely coupled".

As if oft the case Henric has a Blog Post,Circular References that introduces the concept of "loosely coupled" tables, which I quote from below.  [I am a big advocate of Henric's Blog Posts]

To avoid ambiguous results, QlikView marks one of the tables as “loosely coupled”, which means that the logical inference cannot propagate through this table. In the document properties you can decide which table to use as the loosely coupled table. You will get different results from the logical inference depending on which you choose.



Best Regards,    Bill