topic Re: How to resolve this loop? in QlikView

How to resolve this loop?

Fri, 30 May 2014 09:05:49 GMT

Hi all,

I am facing this issue and could not resolve. Appreciate if someone can guide me along.

Basically, I have tried to create key between various tables hoping that it could synchronize the data but it failed.

If I add in the 2 fields (Attribute 1 and 2), then it fails. Otherwise, it works.

Really need to know the walk around for this, thanks.

Below is the scenario:-

ActualSalesTable:

LOAD

Store,

Item,

ActualSales,

Date,

SQL SELECT *

FROM $(DB)$(Comp1)$ActualSalesTable";

ItemTable:

LOAD

Item,

Attribute1,

Attribute2,

SQL SELECT *

FROM $(DB)$(Comp1)$ItemTable";

FiscalYearTable:

LOAD

Date,

Day,

Week,

Month,

Year,

YearWeek

FROM Excel;

BudgetSalesTable: (OK)

LOAD

Year,

Week,

BudgetSales,

YearWeek

FROM Excel;

BudgetSalesTable: (NOT OK AFTER ADDING IN Attribute 1 and 2 -> Failed to synchronize due to loops)

LOAD

Year,

Week,

Attribute1,

Attribute2,

BudgetSales,

YearWeek,

FROM Excel;

Re: How to resolve this loop?

Anonymous — Fri, 30 May 2014 09:10:11 GMT

Try this

LOAD

Year,

Week,

Attribute1 as Att1,

Attribute2 as Att,

BudgetSales,

YearWeek,

FROM Excel;

Re: How to resolve this loop?

Fri, 30 May 2014 09:17:53 GMT

Hi Jebamalai,

Thanks for the reply. I have tried but it reloads properly without any loop issue but not what I want.

This is because the Attribute1 and Attribute2 are part of the important fields in the item master table.

I only change at the BudgetSalesTable but not ItemTable though.

Re: How to resolve this loop?

Anonymous — Fri, 30 May 2014 09:22:03 GMT

Then can you try to Quality the fields

Re: How to resolve this loop?

senpradip007 — Fri, 30 May 2014 09:32:18 GMT

Try this:

ActualSalesTable:

LOAD

'Actual' As Source,

Store,

Item,

ActualSales,

Date,

SQL SELECT *

FROM $(DB)$(Comp1)$ActualSalesTable";

BudgetSalesTable:

LOAD

'Budget' As Source,

Year,

Week,

Attribute1,

Attribute2,

BudgetSales,

YearWeek,

FROM Excel;

Re: How to resolve this loop?

gines_rueda — Fri, 30 May 2014 09:52:38 GMT

I think the main issue is a cyclic relation against FiscalYearTable.

You could try to change

ActualSalesTable

Date to ActualSalesDate

and then create a different calendar.

Cheers.

Re: How to resolve this loop?

Fri, 30 May 2014 10:14:58 GMT

Hi all, thanks for the replies.

Jebamalai,

What do you mean by Quantity the field? Do you mean single code or something?

Pradip Sen,

I have tried using your method but what field should I be taking from the 2 tables to link up as source?

Gines Rueda,

Yes, I believe so but it is not a 1 table to 1 table, I think here they are 3 tables involved so even if I change the date to ActualSalesDate, I need to lookup from another table for the Attributes on Item Master.

I have seen people using the below command. Will that help and how should I be coding it?

left join <>

resident <>

DROP <>

Re: How to resolve this loop?

Anonymous — Fri, 30 May 2014 10:23:15 GMT

Sorry.It was Qualify

Qualify 'Att*'

Re: How to resolve this loop?

senpradip007 — Fri, 30 May 2014 10:23:17 GMT

ActualSalesTable:

LOAD

'Actual' As Source,

Store,

Item,

ActualSales,

Date,

SQL SELECT *

FROM $(DB)$(Comp1)$ActualSalesTable";

Concatenate(ActualSalesTable)

LOAD

'Budget' As Source,

MakeWeekDate(Year,Week,1) As Date,

Attribute1 AS Item,

BudgetSales

FROM Excel;

Create a Master Calendar.