Discussion Board for collaboration on QlikView Scripting.
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?
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.
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.
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.
I recommend to resolve it in a data model, that is use one field.
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?
It depends. If it is a st of fixed values (high, mid, low), it is:
LOAD * INLINE [
If it is not fixed but depend on the other pricing fields, it could be like this:
LOAD DISTINCT "pricing sales" as Pricing RESIDENT Sales;
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.