topic Re: Disconnecting references between tables in QlikView

Disconnecting references between tables

Wed, 19 Jun 2013 13:35:56 GMT

I understand that QV automatically connects all tables that use identical field names. Unfortunately, for a specific task I'd need to use identical field names in two different tables, which are not and shall not be connected to each other. Connecting them would result in circular references.

Is there any chance to use the same field name at two different tables and prevent QV from connecting them?

Re: Disconnecting references between tables

Wed, 19 Jun 2013 13:44:56 GMT

sure use QUALIFY before the table and name the fields

Re: Disconnecting references between tables

Anonymous — Wed, 19 Jun 2013 13:47:28 GMT

Marcus,

No, but you can have fields that look identical, for example:

"Product" and "Product "

Notice the space at the end of the second name.

Anyway, it is hard to imaging whay oyu can't just use labels. Besides, if you name fields as I showed above, it will be hard for to choose the correct field in dimensions and expressions.

Regards,

Michael

Re: Disconnecting references between tables

Wed, 19 Jun 2013 14:01:28 GMT

Reason for identical field names is that I use Multiboxes as central elements in my application. See the screenshot below. Multiboxes can only list fields. Users select price categories "low price", "mid price" and "high price". Those categories are used both in retail sales and label accounting; two totally different departments which mustn't be connected to each other.

If those two tables can't be kept separate, this would mean to add "pricing sales" and "pricing LA" as two separate elements in my multiboxes, which is kinda annoying in terms of useability.

Re: Disconnecting references between tables

Anonymous — Wed, 19 Jun 2013 14:04:28 GMT

You can name your fields "pricing sales" and "pricing LA", but use label "Pricing" for both.

Re: Disconnecting references between tables

Wed, 19 Jun 2013 14:05:50 GMT

Still, this would result in two separate Multibox fields, wouldn't it?

Re: Disconnecting references between tables

Anonymous — Wed, 19 Jun 2013 14:13:06 GMT

Marcus,

You want two different fields shown as one? It is quite a different story.

First, that means that they are logically connected. The question is about the appropriate data model.

Second, it is possible to implement even if you have a reason to keep them separately. For example, in addition to pricing sales" and "pricing LA", you can create field "Pricing" as a logical data island to use it in multibox. Selection in "Pricing" can be copied into the "real" pricing fields by a macro. Or, use conditions and/or set analysis expresions to enforce the deiserd behavior, e.g.

if("pricing sales"=Pricing...)

I recommend to resolve it in a data model, that is use one field.

Regards,

Michael

Re: Disconnecting references between tables

Wed, 19 Jun 2013 14:16:57 GMT

Second, it is possible to implement even if you have a reason to keep them separately. For example, in addition to pricing sales" and "pricing LA", you can create field "Pricing" as a logical data island to use it in multibox. Selection in "Pricing" can be copied into the "real" pricing fields by a macro.

This would be a good solution. How to create such a data island?

Re: Disconnecting references between tables

Anonymous — Wed, 19 Jun 2013 14:27:35 GMT

It depends. If it is a st of fixed values (high, mid, low), it is:

Pricing:

LOAD * INLINE [

Pricing

High

Mid

Low];

If it is not fixed but depend on the other pricing fields, it could be like this:

Pricing:

LOAD DISTINCT "pricing sales" as Pricing RESIDENT Sales;

CONCATENATE (Pricing)

LOAD DISTINCT "pricing LA" as Pricing RESIDENT LA;

No field with the same name anywhere in the data model, so it is not connected to anything.

Re: Disconnecting references between tables

Wed, 19 Jun 2013 14:40:01 GMT

I'll give it a shot. If this works, it would be a perfect solution for various tasks.