Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Retrieve information Parent-sons

Hello Guys 

I have an excel structure like this : 

Field One                      Field Two 

256836........113578.524113.115256.256836
N38402.......113578.524113.115256.256836.N38402
N61755.......113578.524113.115256.256836.N61755
N89028.......113578.524113.115256.256836.N89028
N00674 .......113578.524113.115256.256836.N00674
N14190.......113578.524113.115256.256836.N14190
191429.......113578.524113.115256.256836.191429
N40602.......113578.524113.115256.256836.N40602

 

If you see the 255836 is the parent of all the other fields 

So I need for example when i select in Qlik the 255836 i will have directly a new field with his sons :

 

Something like this  : 

255836 ---->  N38402

                          N61755

                          N61755

                          N89028

                          N00674

                          N14190

                          191429

                          N40602

 

(This is just an example I need to Apply that for others examples (if there is a value in the right of the Field One he is his son ))

 

Thank you 

0 Replies