Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Populate Missing Months


hi,

I am trying to populate missing data for KPIs but unable to do.

I have data just like this

q.jpg

and i want just like this


a.jpg

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Check if this is what you want.

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Create a Master calendar and link your date field with that table.

Master Calendar Generation Script

Regards,

Jagan.

Anonymous
Not applicable
Author

hello,

PFA

Anonymous
Not applicable
Author

Thanks Ravi but i am looking for month iterations not Date and my date format is 'DD/MM/YYYY'

Anonymous
Not applicable
Author

Check if this is what you want.

Anonymous
Not applicable
Author

thanks