topic Re: Saldo in Brasil https://community.qlik.com/t5/Brasil/Saldo/m-p/1263020#M45052 <HTML><HEAD></HEAD><BODY><P>Segue;</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14890845392598586 jive_text_macro" jivemacro_uid="_14890845392598586"> <P>RangeSum(Above(Column(1),0,NoOfRows(TOTAL)))-Column(2)</P> </PRE></BODY></HTML> Thu, 09 Mar 2017 18:33:13 GMT mario_sergio_ti 2017-03-09T18:33:13Z Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263017#M45049 <HTML><HEAD></HEAD><BODY><P>Tenho a Colunas Compras e a Meta</P><P>Gostaria de fazer o saldo </P><P>Exemplo:</P><P>1 - 156.006.61&nbsp; 3360000&nbsp;&nbsp; 3203,993,93</P><P>2 - 186499,59&nbsp; 3360000&nbsp;&nbsp;&nbsp; 3017,494,34</P><P>etc...</P><P></P><P></P><P>Alguma dica.</P><P></P><P>Campo campo:</P><P>Sum({&lt;[NAT_OPER]={'*101','*124','*102','*120','*111'}&gt;} VLR_TOT_FAT - VLR_IPI)</P><P></P><P>Campo Meta:</P><P>$(vCompras)</P><P></P><P><IMG alt="2017-03-09_14-56-16.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155794_2017-03-09_14-56-16.png" style="height: auto;" /></P></BODY></HTML> Thu, 09 Mar 2017 18:01:43 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263017#M45049 Ribeiro 2017-03-09T18:01:43Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263018#M45050 <HTML><HEAD></HEAD><BODY><P>Segue;</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14890828549477295 jive_text_macro" jivemacro_uid="_14890828549477295" modifiedtitle="true"> <P>Column(2)-Column(1)</P> </PRE></BODY></HTML> Thu, 09 Mar 2017 18:05:10 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263018#M45050 mario_sergio_ti 2017-03-09T18:05:10Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263019#M45051 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">É saldo descrente, ele vai dimunido para saldo anterior.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Exemplo:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1 - 156.006.61&nbsp; 3360000&nbsp;&nbsp; 3203,993,93</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2 - 186499,59&nbsp; 3360000&nbsp;&nbsp;&nbsp; 3017,494,34</P><P></P><P></P><P><IMG alt="2017-03-09_15-16-15.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155818_2017-03-09_15-16-15.png" style="height: auto;" /></P></BODY></HTML> Thu, 09 Mar 2017 18:18:15 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263019#M45051 Ribeiro 2017-03-09T18:18:15Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263020#M45052 <HTML><HEAD></HEAD><BODY><P>Segue;</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14890845392598586 jive_text_macro" jivemacro_uid="_14890845392598586"> <P>RangeSum(Above(Column(1),0,NoOfRows(TOTAL)))-Column(2)</P> </PRE></BODY></HTML> Thu, 09 Mar 2017 18:33:13 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263020#M45052 mario_sergio_ti 2017-03-09T18:33:13Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263021#M45053 <HTML><HEAD></HEAD><BODY><P>Como faço para tirar o sinal de negativo Mario, funcionou...</P></BODY></HTML> Thu, 09 Mar 2017 18:45:36 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263021#M45053 Ribeiro 2017-03-09T18:45:36Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263022#M45054 <HTML><HEAD></HEAD><BODY><P>Manda um print para entender.</P><P></P><P>Mas a função que retorna o valor absoluto é:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14890854128383024 jive_text_macro" jivemacro_uid="_14890854128383024" modifiedtitle="true"> <P><SPAN class="Bold">Fabs( </SPAN><SPAN style="font-weight: inherit; font-style: inherit; color: black; background-color: inherit; font-size: 9pt !important;"><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">RangeSum(Above(</SPAN><SPAN class="keyword" style="font-weight: inherit; font-style: inherit; color: #006699; background-color: inherit; font-size: 9pt !important;">Column</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">(1),0,NoOfRows(TOTAL)))-</SPAN><SPAN class="keyword" style="font-weight: inherit; font-style: inherit; color: #006699; background-color: inherit; font-size: 9pt !important;">Column</SPAN><SPAN style="font-weight: inherit; font-style: inherit; background-color: inherit; font-size: 9pt !important;">(2) </SPAN></SPAN><SPAN class="Bold">)</SPAN></P> </PRE></BODY></HTML> Thu, 09 Mar 2017 18:48:03 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263022#M45054 mario_sergio_ti 2017-03-09T18:48:03Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263023#M45055 <HTML><HEAD></HEAD><BODY><P>Funcionou</P><P>A questão é a mesma...</P><P><A href="https://community.qlik.com/thread/252761">Criar Saldo acumulado</A></P></BODY></HTML> Thu, 09 Mar 2017 18:54:13 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263023#M45055 Ribeiro 2017-03-09T18:54:13Z Re: Saldo https://community.qlik.com/t5/Brasil/Saldo/m-p/1263024#M45056 <HTML><HEAD></HEAD><BODY><P>Blz...</P><P>Exclui a outra pergunta então....</P><P>Abraço.</P></BODY></HTML> Thu, 09 Mar 2017 18:55:47 GMT https://community.qlik.com/t5/Brasil/Saldo/m-p/1263024#M45056 mario_sergio_ti 2017-03-09T18:55:47Z