topic Re: Set Analysis and functions... in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947820#M326350 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>Please read this paper, hope it help you understand the solution:</P><P></P><P></P><P><A class="" href="https://community.qlik.com/servlet/JiveServlet/previewBody/6798-102-1-8466/Les_set_analysis_ENG%5B1%5D.pdf">https://community.qlik.com/servlet/JiveServlet/previewBody/6798-102-1-8466/Les_set_analysis_ENG%5B1%5D.pdf</A></P><P></P><P>Thanks for marking my answer as the correct one <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Have a happy weekend <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Oct 2015 14:26:31 GMT miguelbraga 2015-10-09T14:26:31Z Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947813#M326343 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P>Can we make work a set analysis with a function inside ??</P><P>This is my expression :</P><P>sum({&lt;Soldes.num_Mois={'10'}&gt;}Soldes.solde)</P><P></P><P>It works perfectly but I would like the 10 ( the number of the current month to be calculated automatically), so I've tried:</P><P><SPAN style="font-size: 12pt;">({&lt;<SPAN style="color: #800000;">Soldes.num_Mois</SPAN>={ Num(<SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN></SPAN><SPAN style="font-size: 12pt;">()))&nbsp; }&gt;}Soldes.solde) </SPAN></P><P><SPAN style="font-size: 12pt;">But there is an "error modifier ad hoc element list"</SPAN></P><P><SPAN style="font-size: 12pt;">I have also tried : </SPAN></P><P><SPAN style="font-size: 12pt;">({&lt;<SPAN style="color: #800000;">Soldes.num_Mois</SPAN>={ <SPAN style="color: #800000;">"Num(Month(Today()))"</SPAN>&nbsp; }&gt;}<SPAN style="color: #800000;">Soldes.solde</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P><SPAN style="font-size: 12pt;">The Expresision is "ok" but the result is not what I expect, the result is as if I hadn't put any set analysis...</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Do you know what is wrong in the syn,tax?</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thank you for your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 09 Oct 2015 14:08:40 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947813#M326343 2015-10-09T14:08:40Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947814#M326344 <HTML><HEAD></HEAD><BODY><P>add a variable for&nbsp; Num(<SPAN style="color: #0000ff;">Month</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN><SPAN style="font-size: 12pt;">())</SPAN> and then replace it in the expression with the variables</P></BODY></HTML> Fri, 09 Oct 2015 14:11:19 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947814#M326344 villegasi03 2015-10-09T14:11:19Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947815#M326345 <HTML><HEAD></HEAD><BODY><P>I have also tried it and it doesn't work as well</P></BODY></HTML> Fri, 09 Oct 2015 14:13:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947815#M326345 2015-10-09T14:13:18Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947816#M326346 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>Have you tried this?</P><P><STRONG><STRONG></STRONG></STRONG></P><P></P><P>$(=max(Month(Today()))) </P><P><STRONG></STRONG></P><P></P><P>Instead of</P><P></P><P><SPAN style="color: #800000;">"Num(Month(Today()))" .</SPAN></P><P><SPAN style="color: #800000;"><BR /></SPAN></P><P>Miguel&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Oct 2015 14:14:07 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947816#M326346 miguelbraga 2015-10-09T14:14:07Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947817#M326347 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">Soldes.num_Mois</SPAN>={ <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">$(Num(Month(Today())))</SPAN>&nbsp; }&gt;}<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">Soldes.solde</SPAN></SPAN><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</SPAN></P></BODY></HTML> Fri, 09 Oct 2015 14:14:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947817#M326347 nagaiank 2015-10-09T14:14:53Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947818#M326348 <HTML><HEAD></HEAD><BODY><P>Thank you, it works !!</P><P></P><P>But I don't understand why <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P><P></P><P>Can you explain me how the "max" make it work ?</P></BODY></HTML> Fri, 09 Oct 2015 14:20:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947818#M326348 2015-10-09T14:20:18Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947819#M326349 <HTML><HEAD></HEAD><BODY><P>yes. please do. seems like there would only be one max month to todays month. Was it the addition of the " = " that made that work?</P></BODY></HTML> Fri, 09 Oct 2015 14:23:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947819#M326349 villegasi03 2015-10-09T14:23:06Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947820#M326350 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>Please read this paper, hope it help you understand the solution:</P><P></P><P></P><P><A class="" href="https://community.qlik.com/servlet/JiveServlet/previewBody/6798-102-1-8466/Les_set_analysis_ENG%5B1%5D.pdf">https://community.qlik.com/servlet/JiveServlet/previewBody/6798-102-1-8466/Les_set_analysis_ENG%5B1%5D.pdf</A></P><P></P><P>Thanks for marking my answer as the correct one <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Have a happy weekend <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Oct 2015 14:26:31 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947820#M326350 miguelbraga 2015-10-09T14:26:31Z Re: Set Analysis and functions... https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947821#M326351 <HTML><HEAD></HEAD><BODY><P>Also you can see this post on the community:</P><P></P><P></P><P><A class="jive-link-wiki-small" data-containerid="2049" data-containertype="14" data-objectid="6593" data-objecttype="102" href="https://community.qlik.com/docs/DOC-6593">https://community.qlik.com/docs/DOC-6593</A></P><P></P><P>Have a good job <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Oct 2015 14:34:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-functions/m-p/947821#M326351 miguelbraga 2015-10-09T14:34:36Z