Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I hate looping issue of table structure

What should I do? I really need to make this work...

I have tables,

RR_Header

     rr_number

     date

RR_Details

     rr_number

     item_code

     received_qty

DR_Header

     dr_number

     date

DR_Details

     dr_number

     item_code,

     delivered_qty

THIS IS ONLY SIMPLE TABLES....

RR_Header should link to RR_Details (rr_number)

DR_Header should link to DR_Details (dr_number)

RR_Details should link to RR_Details (item_code)

RR_Header should link to DR_Header (date)

So date I could have this report...

DATEITEMDELIVEREDRECEIVED
12-12-12A1015
11-11-11B58

but damn, i hate this thing... TABLE STRUCTURE LOOP... Whatever! It made my blood gets hot... Please help me about this...

I really need to meet the deadline...

I've attached the screenshot of the table structure...

12 Replies
Not applicable
Author

Hi Mig,

I will apply the latest one okay? Will inform once work!

Regards,

Bill

Not applicable
Author

Hi Mig,

Have you check on this?

What if the dr_number of DR_Details should be link to SR_Details ref_no

Consider the following tables and data is related to above...

Example:

DR Detail

     Item    dr_number

     A          DR001

     A          DR002

     B          DR001

SR_Details

     sr_number     Item     ref_no      Returned Qty

        SR01            A         DR001               15

        SR02            B         DR001               8

SR_Header

     sr_number     date return

     SR01               12-15-12

     SR02               11-20-12

I need to have this report

1)     DATE     ITEM     RETURN DATE     DELIVERED     RETURN

2)     DATE     ITEM     SELL OUT     SELL IN

*Sell out = Delivered - Return

*Sell In = Received

-I did what you have did w/ second qvw, I've notice the item has been link between DR Details and SR Details, could you make it DR Details (dr_number) and SR_Header (ref_no) ?

-Im sorry I forgot to tell you that the ref_no is not in SR_Details... it is in SR_Header...

The link of SR_Header to DR_Details is below

     SR_Header

          ref_no as dr_number

     SR_Details

          dr_number

something like that... Hehe

Not applicable
Author

Hi Mig,

     Thanks for the help. I come up this structure. Thanks for the ideas. Got knowledge. Hehe

tablestructure.png

Best Regards,

Bill