topic Re: Qlikview circular loop - how to avoid it in QlikView

Qlikview circular loop - how to avoid it

agigliotti — Wed, 25 Oct 2017 08:10:01 GMT

Hello,

Attached is a sample qvw file with sample data and the circular loop.

What could be done in data model to avoid it ?

Could someone guide me in the right direction ?

Many thanks in advance.

Best Regards

Andrea

Re: Qlikview circular loop - how to avoid it

Anonymous — Wed, 25 Oct 2017 08:59:48 GMT

Hi Andrea,

Remove the table:

/*[Sales network-Item category]:

LOAD * INLINE [

Sales network, Item category,

I, PC

I, SC

F, PC

H, SC

];

as it is a linking table but all the table are already linked without it.

Re: Qlikview circular loop - how to avoid it

agigliotti — Wed, 25 Oct 2017 09:18:09 GMT

Aron,

I need that table because a sales network can sell only items of categories linked.

Re: Qlikview circular loop - how to avoid it

antoniotiman — Wed, 25 Oct 2017 09:29:25 GMT

What about this Data Model ?

Re: Qlikview circular loop - how to avoid it

agigliotti — Wed, 25 Oct 2017 10:02:19 GMT

did you merge four tables into one?

I don't think it's could works for my requirements.

specially because the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date, to what sales network and item category the sales agent belonged to.

Re: Qlikview circular loop - how to avoid it

Anonymous — Wed, 25 Oct 2017 10:40:06 GMT

You say 'the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date'

How do anticipate they will submit this date ?

Then what selection ~~do you expect will happen ?~~

I somehow suspect you'll need to create a SCD [Slowly Changing Dimension] table quite likely by exploiting IntervalMatch().

Are there any other requirements not mentioned in your original question ?

Re: Qlikview circular loop - how to avoid it

satheshreddy — Wed, 25 Oct 2017 10:46:21 GMT

Hi Andrea,

if you want all tables with association better to cut association between two tables it will go out loops.

Regards

Sathish

Re: Qlikview circular loop - how to avoid it

agigliotti — Wed, 25 Oct 2017 12:46:29 GMT

Thanks to all for your quickly reply.

Finally I decided to rename the field "Item category" of table "Sales network-Item category" to "Network category".

In this way I can show in UI both dimensions in order to check if the sales agent sold items that he should not.

Andrea

Re: Qlikview circular loop - how to avoid it

hic — Fri, 27 Oct 2017 13:44:38 GMT

If you want some reading on circular references and how to solve them, take a look at Circular References.

HIC

Re: Qlikview circular loop - how to avoid it

vvvvvvizard — Fri, 27 Oct 2017 13:49:28 GMT

Comment out any one of the same field name that is appearing in two different tables which is causing the circular refeence