Loop

[#1]

Hi guys ,

I have 3 tables nokia,samsung and LG,

The connection between three table is like this

Nokia(saleskey) connected to LG ( Sales key)  and from LG ( dip ) it is connected to samsung(dip).

but in Nokia we have a date column and in samsung also we have date column  this is creating a loop . i cannot comment any one of the date field , and also iam using master calender in this using the date field only , How do  i resolve this issue .

Thanks in advance

[arulsettu]

hi

try to concatenate the tables

[#3]

This will help you - How to avoid circular loops in the Qlikvew Data model

[Anonymous]

HI,

Just rename the fields in your tables:

for table samsung:

date as samsung.date

for table nokia:

date as nokia.date

and for your master calendar you will have to choose which date you want to use: samsung.date OR nokia.date

If you prefer to combien the two dates in the master calendar, then you will have to connect your table samsung to nokia instead of lg using the field date.

[Anonymous]

You can use qualify function and qualify the date fields in both the tables Nokia and Samsung. It will give the name of fields as Nokia.Date and Samsung.Date. Use different master calendars for dates in different tables.

[giakoum]

http://community.qlik.com/message/273800#273800

[#7]

try to concatenate those 3 together into one table