Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shetty_1
Partner - Contributor II
Partner - Contributor II

generating Missing Months

Hi All,

I need a solution on the below logic

Actual Data:

Material No month yearValue 
10000111Sep20183750 
10000111Oct20181500 
10000111Apr2019

0

 
10000111Oct201910987 

 

Expected Output:

Material Nomonth yearValue
10000111Sep20183750
10000111Oct20181500
10000111Nov20181500
10000111Dec20181500
10000111Jan20191500
10000111Feb20191500
10000111Mar20191500
10000111Apr20190
10000111May 20190
10000111June 20190
10000111July 20190
10000111Aug 20190
10000111Sep 20190
10000111Oct 201910987
10000111Nov 201910987
10000111Dec 201910987

 

Thanks In Advance

Regards,

S Shetty

Labels (1)
2 Replies
shivanisapkale
Partner - Creator
Partner - Creator

Hello,

For getting the below expected output you need to create a master calendar for the month so that it will create a missing month year and you can create date as well in case you need it.

After creating month year sort the data in ascending order according to the MonthYear and then use if and previous function to take previous value for missing months.

 

Regards,

Shivani Sapkale

shetty_1
Partner - Contributor II
Partner - Contributor II
Author

Hi Shivani,

Thanks for the solution.

Can you just send me the code? So that I can work on it. 

With the same data can you send me the code. So that it will be helpful for me.