topic Re: Subtotal até a data atual in Brasil https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649246#M18290 <HTML><HEAD></HEAD><BODY><P>Bom dia.</P><P>É mais ou menos assim:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Data</SPAN><SPAN style="font-size: 8pt;">&lt;=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">(),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Valor</SPAN><SPAN style="font-size: 8pt;">,0)) </SPAN></P><P><SPAN style="font-size: 8pt;">Basta você adaptar os seus campos.</SPAN></P></BODY></HTML> Fri, 19 Sep 2014 13:49:49 GMT lucianosv 2014-09-19T13:49:49Z Subtotal até a data atual https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649245#M18289 <HTML><HEAD></HEAD><BODY><P>Olá Pessoal,</P><P></P><P>Como faço para obter numa caixa de texto o montante previsto (Total Prev) até a data de hoje, ou seja, não posso considerar os meses faltantes para o fim do ano.</P><P>O resultado tem que dar R$ 638.416.728,00</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR><TD colspan="1">Mês</TD><TD colspan="1">PL Prev</TD><TD colspan="1">EM Prev</TD><TD colspan="1">Total Pre</TD><TD colspan="1">PL Efetivdo</TD><TD colspan="1">EM Efetiv</TD><TD colspan="1">Total Efetivado</TD><TD colspan="1">Empenho</TD><TD colspan="1">OB</TD><TD colspan="1">DataPgto</TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">jan</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>61916667</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>61916667</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013NE440092</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013OB847886</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/01/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">fev</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>62500000</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>62500000</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB806534</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19/02/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">mar</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">abr</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>73863636</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>73863636</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB812094</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/04/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">abr</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB815257</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">22/04/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">mai</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB819098</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">20/05/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">jun</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB823308</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">13/06/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">jul</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB826031</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">09/07/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">ago</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB830475</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">08/08/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">set</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181812</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>68181812</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014NE442502</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014OB837504</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">12/08/2014</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">out</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">nov</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">dez</SPAN></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>68181818</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>11620273</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#88a8b3"><SPAN style="color: #ffffff;"><STRONG>79802091</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#b4ac76"><SPAN style="color: #ffffff;"><STRONG>0</STRONG></SPAN><STRONG> </STRONG></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD><TD bgcolor="#ffffff"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 19 Sep 2014 13:26:32 GMT https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649245#M18289 2014-09-19T13:26:32Z Re: Subtotal até a data atual https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649246#M18290 <HTML><HEAD></HEAD><BODY><P>Bom dia.</P><P>É mais ou menos assim:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Data</SPAN><SPAN style="font-size: 8pt;">&lt;=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">(),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Valor</SPAN><SPAN style="font-size: 8pt;">,0)) </SPAN></P><P><SPAN style="font-size: 8pt;">Basta você adaptar os seus campos.</SPAN></P></BODY></HTML> Fri, 19 Sep 2014 13:49:49 GMT https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649246#M18290 lucianosv 2014-09-19T13:49:49Z Re: Subtotal até a data atual https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649247#M18291 <HTML><HEAD></HEAD><BODY><P>Deu certo. Valeu!</P></BODY></HTML> Fri, 19 Sep 2014 13:58:02 GMT https://community.qlik.com/t5/Brasil/Subtotal-at%C3%A9-a-data-atual/m-p/649247#M18291 2014-09-19T13:58:02Z