topic Re: help with addmonths fn. in QlikView https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103495#M365690 <HTML><HEAD></HEAD><BODY><P>Hi arusanah,</P><P>Addmonths add or substract months from a given date. If you want the months selected by user, use GetSelectedCount only, you don't need Addmonths function.</P><P></P><P>Regards!</P></BODY></HTML> Tue, 14 Jun 2016 06:55:38 GMT Anonymous 2016-06-14T06:55:38Z help with addmonths fn. https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103492#M365687 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;">=</STRONG></SPAN><SPAN style="font-size: 18pt;"><STRONG style=": ; color: #0000ff;">Addmonths(Getselectedcount(MonthYear)</STRONG></SPAN><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;">) </STRONG></SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;"><BR /></STRONG></SPAN><SPAN style="font-size: 8pt;"><STRONG style=": ; font-size: 14pt;">I am using getselectedcount to get count of months selected. I want to modify the above expression so that it can return back same no of months as returned by get selected count function. pls help.</STRONG></SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;"><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;"><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 8pt;"><STRONG style="font-size: 18pt;"> <BR /></STRONG></SPAN></P></BODY></HTML> Mon, 13 Jun 2016 17:27:53 GMT https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103492#M365687 arusanah 2016-06-13T17:27:53Z Re: help with addmonths fn. https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103493#M365688 <HTML><HEAD></HEAD><BODY><P>I don't understand the reason to use AddMonths() function here? Can you re-elaborate please?</P></BODY></HTML> Mon, 13 Jun 2016 17:30:01 GMT https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103493#M365688 sunny_talwar 2016-06-13T17:30:01Z Re: help with addmonths fn. https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103494#M365689 <HTML><HEAD></HEAD><BODY><P>May be<STRONG> GetFieldSelections(MonthYear)</STRONG></P></BODY></HTML> Mon, 13 Jun 2016 17:30:59 GMT https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103494#M365689 sunny_talwar 2016-06-13T17:30:59Z Re: help with addmonths fn. https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103495#M365690 <HTML><HEAD></HEAD><BODY><P>Hi arusanah,</P><P>Addmonths add or substract months from a given date. If you want the months selected by user, use GetSelectedCount only, you don't need Addmonths function.</P><P></P><P>Regards!</P></BODY></HTML> Tue, 14 Jun 2016 06:55:38 GMT https://community.qlik.com/t5/QlikView/help-with-addmonths-fn/m-p/1103495#M365690 Anonymous 2016-06-14T06:55:38Z