Getting rid of loop

Wed, 09 Dec 2015 23:23:34 GMT

Hi,

I have the following attached tables in my data model. How can I avoid creating loop?

Thanks,

Re: Getting rid of loop

eduardo_sommer — Thu, 10 Dec 2015 01:25:33 GMT

Hi,

One possible solution is to rename the Company Region in the Tax Rates table to Tax Region AND bringing the Company Region from the COMPANY table to the FACT table (via a join or applymap) giving it also the name Tax Region. This will produce a synthetic key between The Tax Rates and the FACT Table, which can be resolved using a concatenated or autonumber field for the Year and Tax Region fields, maintaining both fields in the more granular side.

Something like:

COMPANY:

Load [Company Name],

[Company Region],

[Region Group],

[Company Division],

[Company Location]

From ...;

MapCompanyRegion:

Mapping

Load [Company Name],

[Company Region]

Resident COMPANY;

FACT:

Load Year & '|' [Company Region] as YearRegion,

[Company Name],

KEY,

[Reporting Currency],

Month,

Amount;

Load Year,

[Company Name],

ApplyMap('MapCompanyRegion', [Comapny Name]) as [Company Region],

KEY,

[Reporting Currency],

Month,

Amount

From ...;

TaxRates:

Load Year& '|' & [Company Region] as YearRegion,

Year,

[Company Region] as [Tax Region],

[Tax Rate]

From ...;

I hope this will help you

Regards

Eduardo

Re: Getting rid of loop

Siva_Sankar — Thu, 10 Dec 2015 01:47:48 GMT

Sheetal,

There are many ways to avoid. Circular References

I have attached the example based on your attached image.

Regards,

siva sankar

topic Getting rid of loop in QlikView

Getting rid of loop

Re: Getting rid of loop

Re: Getting rid of loop