topic Sintaxis problem with '&lt;' into a set analisys expression in QlikView https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411267#M153107 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the attached field, the column 'Est.' is made of this expresion:</P><P></P><P>sum({&lt;FECRSA=Corte&gt;}I_ESTANCIAS)</P><P></P><P>being 'FECRSA' and 'I_ESTANCIAS' fields of the pivot table and being 'Corte' a list of dates.</P><P></P><P>The expression works OK but I need FECRSA<STRONG>&lt;</STRONG>=Corte and I'm not able to write so without syntaxis error because of the '&lt;'.</P><P></P><P>How should I write this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 10 Jan 2013 11:21:35 GMT 2013-01-10T11:21:35Z Sintaxis problem with '<' into a set analisys expression https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411267#M153107 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the attached field, the column 'Est.' is made of this expresion:</P><P></P><P>sum({&lt;FECRSA=Corte&gt;}I_ESTANCIAS)</P><P></P><P>being 'FECRSA' and 'I_ESTANCIAS' fields of the pivot table and being 'Corte' a list of dates.</P><P></P><P>The expression works OK but I need FECRSA<STRONG>&lt;</STRONG>=Corte and I'm not able to write so without syntaxis error because of the '&lt;'.</P><P></P><P>How should I write this?</P><P></P><P>Thanks</P></BODY></HTML> Thu, 10 Jan 2013 11:21:35 GMT https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411267#M153107 2013-01-10T11:21:35Z Re: Sintaxis problem with '<' into a set analisys expression https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411268#M153108 <HTML><HEAD></HEAD><BODY><P>try this:</P><P></P><P>sum({&lt;FECRSA={"&lt;=$(=Corte)"} &gt;} I_ESTANCIAS)</P></BODY></HTML> Thu, 10 Jan 2013 11:47:57 GMT https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411268#M153108 adamwilson 2013-01-10T11:47:57Z Re: Sintaxis problem with '<' into a set analisys expression https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411269#M153109 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">FINALLY</SPAN><SPAN>!</SPAN></SPAN></P><P></P><P>Thank you very much Adam.</P></BODY></HTML> Thu, 10 Jan 2013 11:53:33 GMT https://community.qlik.com/t5/QlikView/Sintaxis-problem-with-lt-into-a-set-analisys-expression/m-p/411269#M153109 2013-01-10T11:53:33Z