Preventing Circular References in Qlikview

CircularRefCircular references are common when building a data model.  A circular reference in a data model means that there is more than one way QV can resolve a query across 2 tables. There are a few good ways to avoid circular reference issues when creating a data model:

  1. Merge tables in to a single table using CONCATENATE.
  2. Create link table.
  3. Use data island.

Here’s an example of concatenation and link table methods from the QuickQlearQool site:

There are several solutions to prevent such loops like the concatenate function or link table. Although the best solution to fix circular references depend on the situation, I personally prefer the link table most of the time. When you have two fact tables for example, which shares more then one dimension,  it means there is circular reference.

Matt Floyd‘s insight:

Preventing circular references is key to creating good Qlikview applications and avoiding the dreaded circular reference error. Qlikview best practice is to use the CONCATENATE function.

Follow

Get every new post delivered to your Inbox

Join other followers: