topic Re: Circular ref ::: in QlikView

Circular ref :::

Thu, 08 Oct 2015 06:14:49 GMT

I want one scenario for Circular Reference ,

after loading the tables it will associate based on the primary key(comman key) ,

so the data model look like not well but how it show the bad results means wrong results can anybody give one scenario and any other disadvantages .

Thanks

Madhu

Re: Circular ref :::

MK_QSL — Thu, 08 Oct 2015 06:17:29 GMT

Circular References

Re: Circular ref :::

sujeetsingh — Thu, 08 Oct 2015 06:29:47 GMT

Follow this too

Drawbacks of circular reference and Synthetic key

Re: Circular ref :::

SreeniJD — Thu, 08 Oct 2015 06:30:55 GMT

"Qualify" statement definitely help you to avoid synthetic key and circular reference

HTH

Sreeni

Re: Circular ref :::

Thu, 08 Oct 2015 06:35:01 GMT

Thank u Sreeni,

I am not asking how to solve the circular ref , i am asking how to show the bad results .

Thanks

Madhu

Re: Circular ref :::

SreeniJD — Thu, 08 Oct 2015 06:47:52 GMT

Madhu - You might be aware that when you have common keys across dimensions, circular references will be formed... so the best example is have two tables, one with 100 rows and another with 2/3 rows of data and form a circular reference.

What you can observe with a circular reference is, your query may get data from table2 which has less rows and actually you might expect the result from table1 where you have good data.. because of loosely connected tables

Sreeni