Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael_gerhardt
Contributor
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
Labels (1)
1 Solution

Accepted Solutions
7 Replies
el_aprendiz111
Specialist
Specialist

Rafael como estas

tienes una muestra en excell

Saludo,

rafael_gerhardt
Contributor
Contributor
Author

el_aprendiz111
Specialist
Specialist

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

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

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

Hi,

rafael_gerhardt
Contributor
Contributor
Author

WOW nice!!! So simple

Thank you very very much FER FER!

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