Circular Reference or Loops

[MK_QSL]

Hello Experts...

In enclosed QlikView files, there is a circular reference/loops.

Is there any way to remove the same. Does it make any damage in end result if not removed?

[Anonymous]

Manish

Circular reference/loops will most likely cause issues & confusion.

Have you tried concatenating the TARGET and SALES tables to sort it.

Best Regards,     Bill

[#3]

Hi Manish

Yes you have to choose which key you want for Invoice (InvoiceDate or InvoiceYear)

I understand you need both but I would suggest you create a table with

Customer & InvoiceYear     as %CY,

Customer & InvoiceDate      as %CD,

Customer,      as %C

InvoiceYear  as %Y

InvoiceDate as %D

from Sales

and rearrange your key in other tables

best regards

Chris

[#4]

Hi Manish,

You can join Sales and Target table usign a composite key as below.

check the attached QVW.

Regards,

Shruthi

[MK_QSL]

Shruthi, this is giving me some strange result.

[#6]

Can you explain what d you mean by Strange.I could not reload as I dont have the source files.

[MK_QSL]

Source file is also enclosed....

[#8]

Hi Manish,

see the attached QVW. This will simply solve circular reference and also gives the desired output.

[MK_QSL]

need to compare Sales and Target year wise....

[#10]

Try this: