Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajat1
Partner - Contributor III
Partner - Contributor III

How to generate missing months for a field?

Load * Inline [

MonthYear, user_id

Jan2023,1

Jan2023,3

March2023,1

March2023,3

];

Now i want to autopopulate the missing month that is feb2023 and to create a new field called Occ,

My output should look like, 

MonthYear, user_id,Occ

Jan2023,1,1

Feb2023,1,0

March2023,1,1

Jan2023,3,1

Feb2023,3,0

March2023,3,1

Thanks,

Rajat

Labels (1)
1 Reply
Or
MVP
MVP

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/797824/1/Gener...

The document this was attached to was seemingly removed, but this PDF details all of the necessary techniques for filling in missing data. In your case it's the one covered on pages 7 and 8. This is also covered in a separate document:

https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637