Hi,
This error is caused by how you design your data model in QlikView. Since the data model in QlikView is bi-directional you have to be careful not to create a data model that is circular. By circular I mean :
For Eg. say there are 3 tables Order, Product & Sales with following columns :
| ORDER | PRODUCT | SALES |
|---|
| Order_id | Product_id | Sales_id |
| Product_id | Sales_id | Order_id |
| Sales_Amount | Cust_Name | Voucher_no |
| City_Name | Country | Qty |
| State | Ref | Vehicle |
In the example, ORDER table is joined to PRODUCT table, PRODUCT tabe is joined to SALES table & SALES is again joined to ORDER table causing a loop. If you select a Product_id (from ORDER table), PRODUCT table will be filtered and then the SALES table will be filtered which in turn will filter the ORDER table again and so on. That is so called loop.
In this case, you can try removing the extra links between the tables which are not required. In the example above, one way to avid loop is to remove the link between SALES & ORDER table by renaming the field Order_id in SALES table.
You can do that by:
1. Renaming the fields
2. Using Qualify
It is always ideal/best practice to have just one key field per table.
Hope this helps!
.png "Luminary Alumni"){kind=icon}