topic Methods to break association in QlikView

Methods to break association

Fri, 15 Nov 2013 10:37:18 GMT

Hi All,

What are the methods to break association other than

Rename

Alter states ???

Regards,

Prajna

Re: Methods to break association

kouroshkarimi — Fri, 15 Nov 2013 10:37:48 GMT

Qualify fields.

Re: Methods to break association

Fri, 15 Nov 2013 10:39:19 GMT

how? Can u elaborate?

Regards,

Prajna

Re: Methods to break association

datanibbler — Fri, 15 Nov 2013 10:42:26 GMT

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

Re: Methods to break association

Fri, 15 Nov 2013 10:42:55 GMT

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.

Re: Methods to break association

kouroshkarimi — Fri, 15 Nov 2013 10:44:03 GMT

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

Load Field1,

Field2

Resident Table;

Field1 is the field name.

In the example:

Qualify Field1;

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.

Re: Methods to break association

kouroshkarimi — Fri, 15 Nov 2013 10:45:54 GMT

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.

Re: Methods to break association

Anonymous — Fri, 15 Nov 2013 11:02:10 GMT

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