topic Loop in QlikView

Loop

Fri, 13 Feb 2015 10:48:40 GMT

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

Re: Loop

arulsettu — Fri, 13 Feb 2015 10:55:31 GMT

try to concatenate the tables

Re: Loop

Fri, 13 Feb 2015 13:40:08 GMT

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

Re: Loop

Anonymous — Fri, 13 Feb 2015 14:18:47 GMT

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.

Re: Loop

Anonymous — Fri, 13 Feb 2015 14:28:05 GMT

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.

Re: Loop

giakoum — Fri, 13 Feb 2015 14:58:13 GMT

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

Re: Loop

Fri, 13 Feb 2015 15:03:45 GMT

try to concatenate those 3 together into one table