topic Re: Loop in QlikView

Loop

Tue, 06 Sep 2011 02:02:28 GMT

Hi All,

I have two fact tbles in my model - Slaes and Orders as shown in the figure above. Since the dimension tables join to the fact tables on same ids, qlikView will join the two fact tables as the columns will be same. To resolve this, I aliased the columns in the Orders table to xomehting like OrdColumn name and added an extra column in the dimesnion tables and aliased them accordingly. But am enountering loops error here.Any thoughts on this?

Thanks in advance!

Loop

Tue, 06 Sep 2011 05:37:29 GMT

Concatenate your fact tables to avoid loops.

Fact1:

Load * from fact1.qvd;

Concatenate(Fact1)

Load * from fact2.qvd;

Re: Loop

gandalfgray — Tue, 06 Sep 2011 06:30:49 GMT

One solution is to create just one fact table. You can add a type to be able to distinguish between the different sources involved (Orders and Sales in your case).

Something like this:

Fact:

Load 'Sales' As FactType,

ReportingDate,

CustomerNumber,

...

From Sales;

Concatenate (Fact)

Load 'Orders' As FactType,

ReportingDate,

CustomerNumber,

...

From Orders;

hth/gg

Loop

Tue, 06 Sep 2011 07:02:48 GMT

I have measure in both the fact tables with same name. SO when doing analyis, I'll have to always set this filter, correct?

Re: Loop

Tue, 06 Sep 2011 07:05:52 GMT

Yes, you need to have filter for analysis. Alternativly you can change name of the second fact.

Regards,

Kiran.

Loop

gandalfgray — Tue, 06 Sep 2011 07:06:01 GMT

Either that,

or you can keep the measures in separate fields, like: sales_amount, orders_amount etc.

/gg