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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

roling 13 months in a list box

Hi Friends,

how can i get roling 13 month (Latest 13 month) in a list box

Regards,

Mahesh.G

1 Reply
Anonymous
Not applicable
Author

List box with expression liike this should work:

=if(Month<=MonthStart(today()) and Month>MonthStart(addmonths(today(),-13)), Month)