topic How to generate missing months for a field? in App Development

How to generate missing months for a field?

Rajat1 — Sun, 09 Apr 2023 13:38:05 GMT

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

Re: How to generate missing months for a field?

Or — Sun, 09 Apr 2023 14:09:30 GMT

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/797824/1/Generating%20missing%20data.pdf

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