Stuck in a Loop case

[#1]

Dear All

I am new to Qlikview and stuck with the following load example, i am unable to find the best way to load the following data without having a loop:

Item Table:

ItemType

ItemSection

ItemCode

ItemDescrption

...

Catalog Table:

CatalogCode ( which is also an ItemCode of ItemType Catalog)

ItemCode ( items included in the catalog)

Transaction Table:

ItemCode ( can be itemcode or catalog code)

Warehouse

Date

Quantity

...

The requirement is to view the availabel quantity for a given item code as well as the available quantity for all catalogs containing this item code.

The transaction table is linked to a master Calendar and warehouse table.

Thanks for any help or Hints

Wadih Kharma

[sewialwork]

Hi!

First - if you want your associative data model to work correctly, a unique name should mean a unique field.

Can you show your data model to give a clear perspective? Or maybe sample app?

AGB

[ogautier62]

Hi,

could you provide some rows example under excel and expected result ?

regards