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: 
arieltopaz
Contributor
Contributor

connect demand table with supply table

Hi all

I trying to connect demand table with supply table 

the problem starts with the differences between dates 

demands vs supply 

I will like to get the coverage date from the supply the cover all the demand qty

see example 

this is what I got

mrp_partmrp_due_datemrp_typeWork_Order_Numbermrp_qtyInvmrp_balanceQty_Part_per_DD
CAA45-12304-07-2019DEMAND307110 
CAA45-12307-07-2019DEMAND30811-1 
CAA45-12311-07-2019DEMAND30911-2 
CAA45-12314-07-2019DEMAND31011-3 
CAA45-12318-07-2019DEMAND31111-4 
CAA45-12324-07-2019DEMAND31211-5 
CAA45-12325-07-2019SUPPLY    2
CAA45-12328-07-2019SUPPLY    1
CAA45-12331-07-2019DEMAND31311  

 

this is what I want to get

mrp_partmrp_due_datemrp_typemachine numbermrp_qtyInvmrp_balanceQty_Part_per_DDCover Date
CAA45-12304-07-2019DEMAND307110  
CAA45-12307-07-2019DEMAND30811-1 25-07-2019
CAA45-12311-07-2019DEMAND30911-2 25-07-2019
CAA45-12314-07-2019DEMAND31011-3 28-07-2019
CAA45-12318-07-2019DEMAND31111-4  
CAA45-12324-07-2019DEMAND31211-5  
CAA45-12325-07-2019SUPPLY    2 
CAA45-12328-07-2019SUPPLY    1 
CAA45-12331-07-2019DEMAND31311   

 

the cover date is the supply date that covers 100% of the demand  (part for machine number)

inv - is the inventory today that covers the part for the first machine (307)

in this example, every machine need 1 qty  of this item,  but it is not always like that

mrp_balance  is the qty in shortage for current demands  

Qty_Part_per_DD - is the qty I get in the supply  ( the date for the supply is shown in the field mrp_due_date)

 

no matter what I tried I cannot find the logic to do that 

ill be appreciate your fast help 

 

Thanks

 

 

 

 

 

1 Reply
Brett_Bleess
Former Employee
Former Employee

I believe the first thing you likely need is one of the following topics from the Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Here is the base URL to the Design Blog area you can use to further search if the above gets you on the right track but that leads to further questions...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.