Solved: Fill missing months with data - Qlik Community

JoeWhite · ‎2021-04-29

Hello, everyone.

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

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)

Thanks for help.

JoeWhite · ‎2021-05-12

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

JoeWhite · ‎2021-04-29

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

JoeWhite · ‎2021-05-07

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

JoeWhite · ‎2021-05-12

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

Fill missing months with data