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: 
WH_Aqua
Contributor III
Contributor III

Qlik creating additional rows for table for range between values

Hello Everyone!

I will try to explain my problem as clearly as possible:

I have a table for production tasks, that stores information about:
Prod_Task_Number, Start_Date, End_Date, Product and others.

I also have a table with info from some other documents with information about:
Product, Date_Stored and others.

I want to have is that those two tables are connected by the Product, which is easy, but also by the dates.

So when filtering Prod_Task_Number, I want the second table to show values only for Product associated with that Prod_Task_Number and Date_Stored for all dates between Start_Date and End_Date.

 

Is that doable? And was I clear in my question?

Any help would be greatly appreciated 🙂

Labels (4)
0 Replies