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: 
Mohan23912391
Contributor
Contributor

calendar from min date to max date (YYYYMM)

Hi, I have a PERIOD column which has below periods in YYYYMM format.

PERIOD

202110

202112

202203

but I would like to generate the missing rows. (i.e., 202111, 202201, 202202), how to do that ?

Thanks in advance.

1 Reply
vinieme12
Champion III
Champion III

Refer this post

https://community.qlik.com/t5/New-to-Qlik-Sense/Generate-missing-data/td-p/1937692

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.