Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JoeWhite
Contributor II
Contributor II

Fill missing months with data

Hello, everyone.

I'd like to insert missing months for each Product_ID in table below.

Product_IDStateCountryDate
1AddedSpain01.12.2020
1ModifiedGermany01.02.2021
1DeletedGermany01.04.2021
2AddedSpain01.02.2021

I want to see at which dates product stayed in a country. E.g. Product 1 stayed in Spain since 01.12.2020 till 01.02.2021

Products have 3 states. And if it's not deleted then I want to extend it to monthstart(today()).

Expected result: (added rows colored blue)

Product_IDCountryDate
1Spain01.12.2020
1Spain01.01.2021
1Germany01.02.2021
1Germany01.03.2021
1Germany01.04.2021
2Spain01.02.2021
2Spain01.03.2021
2Spain01.04.2021

Thanks for help.

1 Solution

Accepted Solutions
JoeWhite
Contributor II
Contributor II
Author

I found solution in Generating Missing Data In QlikView post by Henric_Cronström

View solution in original post

3 Replies
JoeWhite
Contributor II
Contributor II
Author

Forgot to mention that I want to achieve this in load script.

JoeWhite
Contributor II
Contributor II
Author

So, is it not possible to do such thing in Qlik?

JoeWhite
Contributor II
Contributor II
Author

I found solution in Generating Missing Data In QlikView post by Henric_Cronström