topic Re: SET Analyst in QlikView https://community.qlik.com/t5/QlikView/SET-Analyst/m-p/339054#M702945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let try (Sum ({$} &lt;Anno_S_A_Prg=<STRONG>{$(=year(V_DATA_FIN))}</STRONG>&gt; Portafoglio_S_A_Prg))</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 06 Aug 2012 09:50:44 GMT Sokkorn 2012-08-06T09:50:44Z SET Analyst https://community.qlik.com/t5/QlikView/SET-Analyst/m-p/339053#M702944 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">qlw</SPAN>'m new, <SPAN class="hps">I</SPAN> <SPAN class="hps">need</SPAN> <SPAN class="hps">to figure out how</SPAN> <SPAN class="hps">to pass</SPAN> <SPAN class="hps">variables</SPAN>: <SPAN class="hps">I declared a</SPAN> <SPAN class="hps">variable in a</SPAN> <SPAN class="hps">slider</SPAN> <SPAN class="hps">object</SPAN> <SPAN class="hps">would</SPAN> <SPAN class="hps">need</SPAN> <SPAN class="hps">to convert</SPAN> <SPAN class="hps">this</SPAN> <SPAN class="hps">variable</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">a set</SPAN> <SPAN class="hps">year</SPAN> <SPAN class="hps">analyst</SPAN>, <SPAN class="hps">and</SPAN> <SPAN class="hps">apply</SPAN> <SPAN class="hps">the function</SPAN> <SPAN class="hps">year</SPAN> <SPAN class="hps">but</SPAN> <SPAN class="hps">something</SPAN> <SPAN class="hps">wrong</SPAN>, I report what <SPAN class="hps">said</SPAN>:<BR /><BR /> <SPAN class="hps">It works</SPAN> <SPAN class="hps">well</SPAN><BR /> <SPAN class="hps atn">(</SPAN>Sum <SPAN class="hps atn">(</SPAN><SPAN class="atn">{</SPAN>$} <SPAN class="hps">&lt;Anno_S_A_Prg={2012}&gt;</SPAN> <SPAN class="hps">Portafoglio_S_A_Prg</SPAN>))<BR /><BR /> <SPAN class="hps">If I pass</SPAN> <SPAN class="hps">the variable</SPAN> <SPAN class="hps">does not work</SPAN><BR /> <SPAN class="hps atn">(</SPAN>Sum <SPAN class="hps atn">(</SPAN><SPAN class="atn">{</SPAN>$} <SPAN class="hps">&lt;Anno_S_A_Prg={year(V_DATA_FIN)}&gt;</SPAN> <SPAN class="hps">Portafoglio_S_A_Prg</SPAN>))<BR /><BR /> <SPAN class="hps">V_DATA_FIN</SPAN> <SPAN class="hps">is a variable</SPAN> <SPAN class="hps">declared</SPAN> <SPAN class="hps">at first and</SPAN> <SPAN class="hps">takes</SPAN> <SPAN class="hps">different values</SPAN> <SPAN class="hps">​​using a</SPAN> <SPAN class="hps">slider</SPAN> <SPAN class="hps">object</SPAN>. <SPAN class="hps">If</SPAN> <SPAN class="hps">used alone</SPAN> <SPAN class="hps">it works and</SPAN> <SPAN class="hps">shows the values</SPAN> <SPAN class="hps">​​correti</SPAN> <SPAN class="hps">insert</SPAN> <SPAN class="hps">in the set</SPAN> <SPAN class="hps">if the</SPAN> <SPAN class="hps">analyst</SPAN> <SPAN class="hps">does not give me</SPAN> <SPAN class="hps">the correct values</SPAN></SPAN></P></BODY></HTML> Mon, 06 Aug 2012 09:42:04 GMT https://community.qlik.com/t5/QlikView/SET-Analyst/m-p/339053#M702944 2012-08-06T09:42:04Z Re: SET Analyst https://community.qlik.com/t5/QlikView/SET-Analyst/m-p/339054#M702945 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let try (Sum ({$} &lt;Anno_S_A_Prg=<STRONG>{$(=year(V_DATA_FIN))}</STRONG>&gt; Portafoglio_S_A_Prg))</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 06 Aug 2012 09:50:44 GMT https://community.qlik.com/t5/QlikView/SET-Analyst/m-p/339054#M702945 Sokkorn 2012-08-06T09:50:44Z