Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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