topic Re: Basic Loop problem in data structure in QlikView

Basic Loop problem in data structure

Wed, 11 Sep 2013 15:49:54 GMT

This is for sure a very simple question, but I don't seem to find a fix for this even after reading several similar cases..

I have this set of tables:

Renewals: Country, ProductCode, some xtra info

Zones: ZoneofWorld, Country

Products: ProductCode, ProdDescription, extra info

Prices: Country,ProductCode, Price

I understand that I have a loop here (I can go from Renewals to Prices using Zones or Products)

But the idea is exactly that (to be able to know how much are the renewals worth, by Zone of World/Country or by Product)

I believe, from what I've read, that one option is to include the info of Zones in Prices table.

I would just like to know if there are any other options since this seems to me to be a fairly common situation.

My sincere regards,

Rui

Re: Basic Loop problem in data structure

Gysbert_Wassenaar — Wed, 11 Sep 2013 16:46:45 GMT

Adding the zone info to the Prices table does seem to be the best option. You could also rename a field. For example if you're not interested in the zone info for prices, only for renewals, you could rename the Country field in the Prices table.

Re: Basic Loop problem in data structure

Wed, 11 Sep 2013 17:16:19 GMT

Wassenar,

thank you very much for your help!!

That small tip really solved my problem!

Many thanks for your time!