Combining two other data sets date into one common table
hi, everyone m new to qlik and have a problem in joining 2 dimensions table into one material table in which the 2 tables are already connected to the material on the basis of material_no key , now the situation is the other two tables are coming up with different dates and havnt any flow into each other but when selection of certain order no it gives the dates from those table . what do i need is to select a common date and it gives the material no from both tables.
hope you guys understand my situation . do ask me if doesnt get the situation .