topic Re: Sumar Fecha in QlikView https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456043#M435193 <HTML><HEAD></HEAD><BODY><P>sim, eu acho que vc e um mestre kkkkkkkkkk, muito brigado ate mais </P></BODY></HTML> Thu, 28 Dec 2017 14:52:12 GMT Anonymous 2017-12-28T14:52:12Z Sumar Fecha https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456041#M435191 <HTML><HEAD></HEAD><BODY><P>Tengo </P><P></P><P>Fecha&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Deuda</P><P>201701&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>201702&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>201703&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</P><P>201704&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>201705&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P></P><P></P><P>Quiero seleccionar 201701 y 201702 y que en dos cuadros me muestre:</P><P></P><P>La suma de 201701 y 201703</P><P>La suma de 201702</P><P>La suma de 201705</P><P></P><P>Gracias </P></BODY></HTML> Wed, 27 Dec 2017 20:16:37 GMT https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456041#M435191 Anonymous 2017-12-27T20:16:37Z Re: Sumar Fecha https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456042#M435192 <HTML><HEAD></HEAD><BODY><P>Não tenho certeza, qual é a lógica por trás, talvez isso?</P><P></P><P><STRONG>If(Match(Fecha, '201701', '201702'), Sum({&lt;Fecha = {<SPAN style="font-size: 13.3333px;">'201701', '201702'</SPAN>}&gt;} Deuda), </STRONG></P><P><STRONG><SPAN style="font-size: 13.3333px;">If(Match(Fecha, '201702'), Sum({&lt;Fecha = {</SPAN><SPAN style="font-size: 13.3333px;">'201702'</SPAN><SPAN style="font-size: 13.3333px;">}&gt;} Deuda), </SPAN></STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG><SPAN style="font-size: 13.3333px;">If(Match(Fecha, '201705'), Sum({&lt;Fecha = {</SPAN><SPAN style="font-size: 13.3333px;">'201705'</SPAN></STRONG><SPAN style="font-size: 13.3333px;"><STRONG>}&gt;} Deuda))))</STRONG></SPAN></SPAN></P></BODY></HTML> Thu, 28 Dec 2017 01:13:38 GMT https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456042#M435192 Anil_Babu_Samineni 2017-12-28T01:13:38Z Re: Sumar Fecha https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456043#M435193 <HTML><HEAD></HEAD><BODY><P>sim, eu acho que vc e um mestre kkkkkkkkkk, muito brigado ate mais </P></BODY></HTML> Thu, 28 Dec 2017 14:52:12 GMT https://community.qlik.com/t5/QlikView/Sumar-Fecha/m-p/1456043#M435193 Anonymous 2017-12-28T14:52:12Z