topic Re: hierarchical documents in Brasil https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332773#M48426 <HTML><HEAD></HEAD><BODY><P>Rafael como estas</P><P></P><P>tienes una muestra en excell</P><P></P><P>Saludo,</P></BODY></HTML> Wed, 24 May 2017 16:43:17 GMT el_aprendiz111 2017-05-24T16:43:17Z hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332772#M48425 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P></P><P>I have a table with hierarchical documents, named DOCs.</P><P>There are three levels, but only two fields for registration.</P><P>DOC field: records the issued document.</P><P>DOCREF field: records the document being changed by DOC.</P><P>I need to group all changes in the original document, in new table, named DOCsOriginal.</P><P>How do I do that?</P><P>Look at the table and the results:</P><P></P><P>DOCs:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 319px;"><TBODY><TR><TD class="xl69" height="20" width="94">Doc</TD><TD class="xl70" width="108">DocREF</TD><TD class="xl71" width="117"> $ </TD></TR><TR><TD class="xl72" height="20">NC1</TD><TD class="xl73"> </TD><TD class="xl74"> 1.000,00 </TD></TR><TR><TD class="xl75" height="20">NC2</TD><TD class="xl76">NC1</TD><TD class="xl77"> 500,00 </TD></TR><TR><TD class="xl72" height="20">NC3</TD><TD class="xl73">NC2</TD><TD class="xl74">- 100,00 </TD></TR><TR><TD class="xl75" height="20">NC4</TD><TD class="xl76">NC1</TD><TD class="xl77"> 50,00 </TD></TR><TR><TD class="xl72" height="21">NC5</TD><TD class="xl73">NC4</TD><TD class="xl74">- 20,00 </TD></TR><TR><TD class="xl66" height="21">Total NC1</TD><TD class="xl67"> </TD><TD class="xl68"> 1.430,00 </TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="font-size: 13.3333px;">DOCsOriginal</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="341"><TBODY><TR><TD class="xl69" height="20" width="94">DocOriginal</TD><TD class="xl70" width="130">DocsChange</TD><TD class="xl71" width="117"> R$ Current </TD></TR><TR><TD class="xl65" height="20">NC1</TD><TD class="xl66">NC2; NC3; NC4; NC5</TD><TD class="xl68"> 1.430,00 </TD></TR></TBODY></TABLE></BODY></HTML> Wed, 24 May 2017 15:09:50 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332772#M48425 rafael_gerhardt 2017-05-24T15:09:50Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332773#M48426 <HTML><HEAD></HEAD><BODY><P>Rafael como estas</P><P></P><P>tienes una muestra en excell</P><P></P><P>Saludo,</P></BODY></HTML> Wed, 24 May 2017 16:43:17 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332773#M48426 el_aprendiz111 2017-05-24T16:43:17Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332774#M48427 <HTML><HEAD></HEAD><BODY><P>yes...</P><P><A href="https://www.dropbox.com/s/t7kxop5qk11jcv9/Tab%20DOCs.xls?dl=0" title="https://www.dropbox.com/s/t7kxop5qk11jcv9/Tab%20DOCs.xls?dl=0">Dropbox - Tab DOCs.xls</A></P></BODY></HTML> Wed, 24 May 2017 18:26:37 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332774#M48427 rafael_gerhardt 2017-05-24T18:26:37Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332775#M48428 <HTML><HEAD></HEAD><BODY><P>Rafael </P><P>1 example</P><TABLE border="0" cellpadding="0" cellspacing="0" width="619"><TBODY><TR><TD style="background: #DDEBF7; padding: 0 3.5pt 0 3.5pt;" width="115"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'inherit',serif; color: black;">Doc</SPAN></P></TD><TD style="background: #DDEBF7; padding: 0 3.5pt 0 3.5pt;" width="400"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'inherit',serif; color: black;">DocREF</SPAN></P></TD><TD style="background: #DDEBF7; padding: 0 3.5pt 0 3.5pt;" width="104"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10.0pt; font-family: 'inherit',serif; color: black;">$</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-right: solid white 1.0pt; background: #EDEDED; padding: 0 3.5pt 0 3.5pt;" width="115"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: red;">2017NE000001</SPAN></P></TD><TD style="border: none; border-right: solid white 1.0pt; background: #EDEDED; padding: 0 3.5pt 0 3.5pt;" valign="bottom" width="400"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN lang="EN-US" style="color: black;">2017NE000091;2017NE000113;2017NE000172;2017NE000249;<BR /> 2017NE000272;2017NE000295;2017NE000316;2017NE000347</SPAN></P></TD><TD nowrap="nowrap" style="background: #EDEDED; padding: 0 3.5pt 0 3.5pt;" width="104"><P style="margin-bottom: .0001pt;"> <SPAN style="color: black;">$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 538.551,52 </SPAN></P></TD></TR></TBODY></TABLE><P>this would be the expected result for this doc</P></BODY></HTML> Wed, 24 May 2017 20:39:55 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332775#M48428 el_aprendiz111 2017-05-24T20:39:55Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332776#M48429 <HTML><HEAD></HEAD><BODY><P>Yes, that's correct. </P><P>Two good examples are the documents 2017NE800102 and 2017NE800103.</P><P>In these cases the three levels are evidenced.</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="72" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="height: 65px; width: 556px;"><TBODY><TR><TH style="color: #000000; background-color: #6690bc; text-align: center; padding: 2px;">DOC</TH><TH style="color: #000000; background-color: #6690bc; text-align: center; padding: 2px;">DOCsREF</TH><TH style="color: #000000; background-color: #6690bc; text-align: center; padding: 2px;">$</TH></TR><TR><TD class="xl65" height="17" style="border-top: none;">2017NE800103</TD><TD class="xl65" style="border-top: none; border-left: none;">2017NE800495; 2017NE800514</TD><TD class="xl66" style="border-top: none; border-left: none;"> 3.000,00 </TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">2017NE800102</TD><TD class="xl65" style="border-top: none; border-left: none;">2017NE800494; 2017NE800513</TD><TD class="xl66" style="border-top: none; border-left: none;"> 6.000,00 </TD></TR></TBODY></TABLE></BODY></HTML> Thu, 25 May 2017 00:32:38 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332776#M48429 rafael_gerhardt 2017-05-25T00:32:38Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332777#M48430 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" height="168" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="height: 122px; width: 404px;"><TBODY><TR><TH style="color: #ffffff; background-color: #000000; text-align: center; padding: 2px;">DOC</TH><TH style="color: #ffffff; background-color: #000000; text-align: center; padding: 2px;">DOCREF</TH><TH style="color: #ffffff; background-color: #000000; text-align: center; padding: 2px;">$</TH></TR><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">2017NE800103</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"> </TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">3.000,00</TH></TR><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">2017NE800495</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">2017NE800103</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">-3.000,00</TH></TR><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">2017NE800514</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">2017NE800495</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">3.000,00</TH></TR><TR><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;">2017NE800102</TH><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;"> </TH><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;">6.000,00</TH></TR><TR><TH style="color: #333333; background-color: #ffff00; text-align: center; padding: 2px;">2017NE800494</TH><TH style="color: #333333; background-color: #ffff00; text-align: center; padding: 2px;">2017NE800102</TH><TH style="color: #333333; background-color: #ffff00; text-align: center; padding: 2px;">-197,00</TH></TR><TR><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;">2017NE800513</TH><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;">2017NE800494</TH><TH style="color: #000000; background-color: #ffff00; text-align: center; padding: 2px;">197,00</TH></TR></TBODY></TABLE></BODY></HTML> Thu, 25 May 2017 00:37:23 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332777#M48430 rafael_gerhardt 2017-05-25T00:37:23Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332778#M48431 <HTML><HEAD></HEAD><BODY><P>Hi,</P></BODY></HTML> Thu, 25 May 2017 16:57:16 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332778#M48431 el_aprendiz111 2017-05-25T16:57:16Z Re: hierarchical documents https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332779#M48432 <HTML><HEAD></HEAD><BODY><P>WOW nice!!! So simple <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P>Thank you very very much FER FER!</P><P></P><P>2017-05-25 13:58 GMT-03:00 Fer Fer &lt;qcwebmaster@qlikview.com&gt;:</P><P></P><BLOCKQUOTE level="1"><P></P></BLOCKQUOTE><P></P></BODY></HTML> Fri, 26 May 2017 13:17:01 GMT https://community.qlik.com/t5/Brasil/hierarchical-documents/m-p/1332779#M48432 rafael_gerhardt 2017-05-26T13:17:01Z