calculating the field value of connected data

engr_farhanqadr — Sun, 26 Oct 2014 20:08:15 GMT

Dear Folks,

I am stuck in a problem , I have the following tables :

1.composite,

2. stock

3.unit cost

In composite table, columns are parentsku, childsku and ratio.

In stock table , coumns are sku , WH , FBA , intransit and PO

In Unit cost ,columns are sku and unit cost

composite table:

parentsku childsku ratio

A b 1

A c 1

A d 1

X z 1

In above table parent sku A have multiple childs(b c d) and X has one.

In stock table , parent and child sku's wh and fba intransit po value are listed and they are different like as:

stock table:

SKU Warehouse FBA On Purchase In Transit

A 22 3 4 5

b 10 6 0 0

c 11 7 0 0

d 12 8 0 0

I want to make a straight table where I want to show the sku , unitcost , wh

In Sku , both parent and child sku will be listed.

In Wh, if parent sku is there in sku column, then its connected childsku's warehouse will be picked and divided by ratio(if parent has only one child).and if child sku is there then its original warehouse will be shown. if parent sku have multiple childs then its childsku's warehouse with minimum value will be picked up.

in unitcost column, if parent sku is there in sku column then its connected child sku unit cost will be picked and multiply by ratio.and if child sku is there then its original unit cost will be shown.

please let me know how to achieve this..

Regards,

Farhan

Re: calculating the field value of connected data

Gysbert_Wassenaar — Mon, 27 Oct 2014 09:34:08 GMT

Can you post an example document with source data and a result table that contains the data you expect in the final straight table?

topic Re: calculating the field value of connected data in QlikView

calculating the field value of connected data

Re: calculating the field value of connected data