topic How to avoid this looping ? in QlikView

How to avoid this looping ?

Sat, 11 Aug 2012 18:04:29 GMT

Hi,

I'am new to Qlikview and developing my first demo example. Can sombody tell me how to solve the following looping problem

Re: How to avoid this looping ?

nilesh_gangurde — Sat, 11 Aug 2012 19:13:02 GMT

Heyy Hiii,

You can avoid the above looping by renaming the fields.

because QlikView connects two tables based on the field names..

Regards,

Nilesh Gangurde

Re: How to avoid this looping ?

Sat, 11 Aug 2012 19:21:50 GMT

Hi,

Thanks, but i have tried to rename the field names but qlikview still gives warnings about loopings. Can you give me an exact example of how i can rename the fields in such way that Qlikview can cope with it.

I my picture i forgot to draw lines where Qlikview thinks that a relation exists, attached you will findthe new accurate pic

Re: How to avoid this looping ?

nilesh_gangurde — Sat, 11 Aug 2012 19:25:59 GMT

Send me the script..

and also the information about which table should connect with wich table by which field...

so i can help you

Regards,

Nilesh Gangurde

Re: How to avoid this looping ?

Sat, 11 Aug 2012 19:52:57 GMT

Hi Nilesh

I send some stuff. As seen in the starschema the FACT_Budget table is

linked to DIM_OrderMonth (DIM_OrderMaand) and DIM_Article (DIM_Artikel, eg

DIM_Product in my question pic) thise should be the correct and intended

links. If i just load the tables you can see in the screenshot which links

Qlikview creates.

Met vriendelijke groet,

2012/8/11 Nilesh Gangurde <qliktech@sgaur.hosted.jivesoftware.com>

**
QlikCommunity <http://community.qlik.com/index.jspa> Re: How
to avoid this looping ? created by Nilesh Gangurde<http://community.qlik.com/people/nilesh.gangurde>in
Community Help - View the full discussion<http://community.qlik.com/message/247624#247624>

Re: How to avoid this looping ?

Tue, 14 Aug 2012 06:31:59 GMT

Hi,

Already a solution for my question????

Met vriendelijke groet,

2012/8/11 Nilesh Gangurde <qliktech@sgaur.hosted.jivesoftware.com>

**
QlikCommunity <http://community.qlik.com/index.jspa> Re: How
to avoid this looping ? created by Nilesh Gangurde<http://community.qlik.com/people/nilesh.gangurde>in
Community Help - View the full discussion<http://community.qlik.com/message/247624#247624>

Re: How to avoid this looping ?

whiteline — Mon, 03 Sep 2012 14:52:11 GMT

You have an ambiguity:

Your ArtikelID connected with OrderDatumID in FACT_Sales and then to OrderMaandID in DIM_Orderdatum.

Also ArtikelID connected with OrderMaandID in FACT_Budget.

You should decide which connection is obsolete and break it.

For example for fact table:

FACT_Budget:

LOAD

ArtikelID,

OrderMaandID as ObsoleteOrderMaandID,

BudgetMaand;

SQL SELECT *

FROM "LDEMO_DMR".dbo."vw_FCT_Budget";