Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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