topic Re: Remove loops in QlikView

Remove loops

Anonymous — Wed, 05 Aug 2015 11:30:51 GMT

I have two fact tables : Budget and vente .

I create a link table to store them but I get loops between tables as it's shown in the following picture .

How to remove loops ?

Re: Remove loops

Colin-Albert — Wed, 05 Aug 2015 11:35:36 GMT

Please don't post the same question multiple times. This question has been posted twice today already!

Re: Remove loops

senpradip007 — Wed, 05 Aug 2015 11:37:00 GMT

Your image is not clear. Please upload a fresh copy.

Re: Remove loops

Colin-Albert — Wed, 05 Aug 2015 11:50:40 GMT

Rename the field "Code Rayon" in either the Budget or Merchandise table.

This will remove the loop.

Re: Remove loops

Anonymous — Wed, 05 Aug 2015 12:18:46 GMT

it returns wrong results

Re: Remove loops

Colin-Albert — Wed, 05 Aug 2015 12:29:26 GMT

Then you will need to include the field in your link table so the association is correct. Otherwise consider concatenating your budget and sales data to a single table.

Re: Remove loops

Anonymous — Wed, 05 Aug 2015 12:32:05 GMT

How to include the field in the link table , I am a newbie with qlikview .How can I concatenate the two table sales and budget , It doesn't have the same columns

Re: Remove loops

kuczynska — Wed, 05 Aug 2015 12:42:45 GMT

Check this article: Understanding Join, Keep and Concatenate

You have few options to remove the loops - rename, remove, join/concatenate tables. You can try to use QUALIFY function at the beginning of the load script to add the prefix (parent table name) to each field name (this will create a set of separate tables) and than slowly build your way up - by UNQUALIFYING the fields that are creating logical associations between tables. As you know, some of the loops might still exist in your data model as that could also be a result of the bad architecture of the model, but in that case there must be a logical/business reason for that kind of implementation. Good luck!