topic Re: Maximum period per year with expansion sign in App Development https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356172#M30288 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Thank you very much for your answer, it is very useful to solve the problem that I have, thanks David</SPAN></P></BODY></HTML> Tue, 30 May 2017 13:43:16 GMT Anonymous 2017-05-30T13:43:16Z Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356166#M30282 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Hello, I have this problem, when I apply a formula to the following years <STRONG>MonthName(Max(Periodo),</STRONG> it returns the last month of the year with data, which is correct, but doing so in this way<STRONG> '$(=MonthName(Max(Periodo)))',</STRONG> brings me the total value, could someone help me, I need the Value in quotation marks for a set analysis&nbsp; <SPAN lang="en">Thank you</SPAN></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;"><SPAN lang="en"><IMG alt="I get this.png" class="jive-image image-1" height="249" src="/legacyfs/online/165130_I get this.png" style="height: 249.188px; width: 261px;" width="261" />&nbsp;&nbsp; <IMG alt="expected.png" class="jive-image image-2" height="260" src="https://community.qlik.com/legacyfs/online/165134_expected.png" style="height: 260.315px; width: 231px;" width="231" /><BR /></SPAN></SPAN></P></BODY></HTML> Mon, 29 May 2017 21:52:31 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356166#M30282 Anonymous 2017-05-29T21:52:31Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356167#M30283 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan,</P><P><STRONG style="color: #212121;"> '$(=MonthName(Max(Periodo)))'</STRONG> is evaluated once per chart.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 30 May 2017 06:59:06 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356167#M30283 antoniotiman 2017-05-30T06:59:06Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356168#M30284 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 16px; font-family: arial, sans-serif; color: #212121;">try without the equal sign<BR /></STRONG></P><P><STRONG style="font-size: 16px; font-family: arial, sans-serif; color: #212121;"><BR /></STRONG></P><P>$(MonthName(Max(Periodo)))</P></BODY></HTML> Tue, 30 May 2017 07:41:49 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356168#M30284 vinieme12 2017-05-30T07:41:49Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356169#M30285 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan,</P><P></P><P>The difference between the $() expressions and the ones without $() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.</P><P></P><P>Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.</P><P><BR />Regards,</P><P>David</P></BODY></HTML> Tue, 30 May 2017 07:44:15 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356169#M30285 daveamz 2017-05-30T07:44:15Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356170#M30286 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 29px;">thanks for your answer Antonio</SPAN></P></BODY></HTML> Tue, 30 May 2017 13:37:42 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356170#M30286 Anonymous 2017-05-30T13:37:42Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356171#M30287 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I already tried, thanks for your answer Vinneeth</SPAN></P></BODY></HTML> Tue, 30 May 2017 13:41:25 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356171#M30287 Anonymous 2017-05-30T13:41:25Z Re: Maximum period per year with expansion sign https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356172#M30288 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 16px;">Thank you very much for your answer, it is very useful to solve the problem that I have, thanks David</SPAN></P></BODY></HTML> Tue, 30 May 2017 13:43:16 GMT https://community.qlik.com/t5/App-Development/Maximum-period-per-year-with-expansion-sign/m-p/1356172#M30288 Anonymous 2017-05-30T13:43:16Z