topic Re: Help me spot the loop in QlikView

Help me spot the loop

Thu, 23 May 2013 16:45:25 GMT

I have an association loop in my structure that I need help finding. The problem occurs when I add the "Item Category Code 2" field association in the Discounts table. I'm brand new to Qlikview and I DID NOT create this structure, so please don't judge

Re: Help me spot the loop

shree909 — Thu, 23 May 2013 16:51:47 GMT

Hi ,

Its associating to the discount table becoz the discount table has item category code 2 ,

try to rename the fieldname .

Qlikivew will join or asssociate ir the field names are similar.. this is the qv default behaviour..

if u dont want to assoicaite try to rename the field names.

Re: Help me spot the loop

Thu, 23 May 2013 16:55:51 GMT

Problem is that I need both associations on the Discounts table.

Re: Help me spot the loop

shree909 — Thu, 23 May 2013 17:07:17 GMT

Hi,

Why dont u join both the discounts and "Item Category Code 2 and make as one table.

Disocunt:

load * fromt Discounts table

Join(Discount)

Load * form "Item Category Code 2

This will create a one table with Discount

with all the fieldnames from discount and "Item Category Code 2

Thanks

Re: Help me spot the loop

Thu, 23 May 2013 18:42:30 GMT

Sorry, Item Category Code 2 is a field name, not a table.

Re: Help me spot the loop

Thu, 23 May 2013 18:56:22 GMT

Nevermind, I see the loop. I just have to figure out how to set a composite key of Customer Number and Item Category Code 2 that come from different tables.