Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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 🙂

0 Replies