Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

rafael_gerhardt
New Contributor

hierarchical documents

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:

DocDocREF $
NC1 1.000,00
NC2NC1 500,00
NC3NC2- 100,00
NC4NC1 50,00
NC5NC4- 20,00
Total NC1 1.430,00

DOCsOriginal

DocOriginalDocsChange R$ Current
NC1NC2; NC3; NC4; NC5 1.430,00
Tags (1)
1 Solution

Accepted Solutions
el_aprendiz111
Valued Contributor

Re: hierarchical documents

Hi,

7 Replies
el_aprendiz111
Valued Contributor

Re: hierarchical documents

Rafael como estas

tienes una muestra en excell

Saludo,

rafael_gerhardt
New Contributor

Re: hierarchical documents

el_aprendiz111
Valued Contributor

Re: hierarchical documents

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
New Contributor

Re: hierarchical documents

Yes, that's correct.

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

In these cases the three levels are evidenced.

   

DOCDOCsREF$
2017NE8001032017NE800495; 2017NE800514 3.000,00
2017NE8001022017NE800494; 2017NE800513 6.000,00
rafael_gerhardt
New Contributor

Re: hierarchical documents

DOCDOCREF$
2017NE800103 3.000,00
2017NE8004952017NE800103-3.000,00
2017NE8005142017NE8004953.000,00
2017NE800102 6.000,00
2017NE8004942017NE800102-197,00
2017NE8005132017NE800494197,00
el_aprendiz111
Valued Contributor

Re: hierarchical documents

Hi,

Highlighted
rafael_gerhardt
New Contributor

Re: hierarchical documents

WOW nice!!! So simple

Thank you very very much FER FER!

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