hierarchical documents

[rafael_gerhardt]

Folks,

I have a table with hierarchical documents, named DOCs.

There are three levels, but only two fields for registration.

DOC field: records the issued document.

DOCREF field: records the document being changed by DOC.

I need to group all changes in the original document, in new table, named DOCsOriginal.

How do I do that?

Look at the table and the results:

DOCs:

Doc	DocREF	$
NC1		1.000,00
NC2	NC1	500,00
NC3	NC2	- 100,00
NC4	NC1	50,00
NC5	NC4	- 20,00
Total NC1		1.430,00

DOCsOriginal

DocOriginal	DocsChange	R$ Current
NC1	NC2; NC3; NC4; NC5	1.430,00

[el_aprendiz111]

Rafael como estas

tienes una muestra en excell

Saludo,

[rafael_gerhardt]

yes...

Dropbox - Tab DOCs.xls

[el_aprendiz111]

Rafael

1 example

Doc	DocREF	$
2017NE000001	2017NE000091;2017NE000113;2017NE000172;2017NE000249; 2017NE000272;2017NE000295;2017NE000316;2017NE000347	$       538.551,52

this would be the expected result for this doc

[rafael_gerhardt]

Yes, that's correct.

Two good examples are the documents 2017NE800102 and 2017NE800103.

In these cases the three levels are evidenced.

DOC	DOCsREF	$
2017NE800103	2017NE800495; 2017NE800514	3.000,00
2017NE800102	2017NE800494; 2017NE800513	6.000,00

[rafael_gerhardt]

DOC	DOCREF	$
2017NE800103		3.000,00
2017NE800495	2017NE800103	-3.000,00
2017NE800514	2017NE800495	3.000,00
2017NE800102		6.000,00
2017NE800494	2017NE800102	-197,00
2017NE800513	2017NE800494	197,00

[el_aprendiz111 · Accepted solution]

Hi,

[rafael_gerhardt]

WOW nice!!! So simple

Thank you very very much FER FER!

2017-05-25 13:58 GMT-03:00 Fer Fer <qcwebmaster@qlikview.com>: