https://community.qlik.com/t5/QlikView/Restrict-the-month/m-p/1776293#M454854 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/76456">@aghabdurauf</a>, and why is the addmonths function with -1, you can add an If to check the date before creating it, but if you don't create the date the fist month of data won't be related to any date.</P> Thu, 21 Jan 2021 12:11:49 GMT rubenmarin 2021-01-21T12:11:49Z https://community.qlik.com/t5/QlikView/Restrict-the-month/m-p/1776272#M454846 <P>Hi all,</P><P>I have 12 months Dates from 31-12-2020 to 30-11-2021</P><P>I use =monthName(addmonths(max(Date_Email), -1))</P><P>when I select 31-12-2020 it shows Nov-2020.</P><P>I want to restrict this however Nov 2020 is not in my data.</P><P>&nbsp;</P><P>Thanks</P> Fri, 15 Nov 2024 23:16:42 GMT https://community.qlik.com/t5/QlikView/Restrict-the-month/m-p/1776272#M454846 aghabdurauf 2024-11-15T23:16:42Z https://community.qlik.com/t5/QlikView/Restrict-the-month/m-p/1776293#M454854 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/76456">@aghabdurauf</a>, and why is the addmonths function with -1, you can add an If to check the date before creating it, but if you don't create the date the fist month of data won't be related to any date.</P> Thu, 21 Jan 2021 12:11:49 GMT https://community.qlik.com/t5/QlikView/Restrict-the-month/m-p/1776293#M454854 rubenmarin 2021-01-21T12:11:49Z