topic Re: Help with set analysis expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427897#M562648 <HTML><HEAD></HEAD><BODY><P>works nice</P><P>thanks a lot</P></BODY></HTML> Mon, 11 Mar 2013 11:29:04 GMT jtrillori 2013-03-11T11:29:04Z Help with set analysis expression https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427893#M562644 <HTML><HEAD></HEAD><BODY><P>morning,</P><P></P><P>how can i convert this expression </P><P><STRONG style="color: #333333;">if(fecha &lt; fecha1 and fecha&gt;(fecha1-365), importe)</STRONG></P><P>in a set analysis expression?</P><P></P><P>thanks and regards</P></BODY></HTML> Mon, 11 Mar 2013 10:40:44 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427893#M562644 jtrillori 2013-03-11T10:40:44Z Re: Help with set analysis expression https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427894#M562645 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">SUM({&lt;<SPAN style="background-color: #ffffff; font-family: Arial;"><STRONG>fecha</STRONG></SPAN>={'&gt;<SPAN style="background-color: #ffffff; font-family: Arial;"><STRONG>(fecha1-365)</STRONG></SPAN>&lt;<SPAN style="background-color: #ffffff; font-family: Arial;"><STRONG>fecha1</STRONG></SPAN>'} &gt;} <SPAN style="background-color: #ffffff; font-family: Arial;"><STRONG>importe</STRONG></SPAN>)</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Mon, 11 Mar 2013 10:50:24 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427894#M562645 er_mohit 2013-03-11T10:50:24Z Re: Help with set analysis expression https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427895#M562646 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">sorry the entire expression is like that</P><P style="text-align: left;">sum(if(<STRONG style="color: #333333;">fecha &lt; fecha1 and fecha&gt;(fecha1-365), importe))</STRONG></P><P></P><P style="text-align: left;"><STRONG style="color: #333333;">thanks</STRONG><STRONG><STRONG style="color: #333333;"><BR /></STRONG></STRONG></P></BODY></HTML> Mon, 11 Mar 2013 10:54:58 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427895#M562646 jtrillori 2013-03-11T10:54:58Z Re: Help with set analysis expression https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427896#M562647 <HTML><HEAD></HEAD><BODY><P>try sum({&lt;fecha={"=fecha&lt;fecha1 and fecha&gt;(fecha1-365)"}&gt;}importe)</P></BODY></HTML> Mon, 11 Mar 2013 11:05:37 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427896#M562647 Gysbert_Wassenaar 2013-03-11T11:05:37Z Re: Help with set analysis expression https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427897#M562648 <HTML><HEAD></HEAD><BODY><P>works nice</P><P>thanks a lot</P></BODY></HTML> Mon, 11 Mar 2013 11:29:04 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis-expression/m-p/427897#M562648 jtrillori 2013-03-11T11:29:04Z