build a path from arc

[Yassine_Gh]

Hello,
I have an arc table containing id, start, end, travel_time see the example attached.
I want to calculate the sum of the travel_times from several selected arc such as Path = start of the next arc = end of the previous arc.
-> Have multiple ARC filter
-> calculate in a graph from several selections.

Thanks for your help

[Gysbert_Wassenaar · Accepted solution]

Well, the arcs could be considered as a hierarchy with each next step being the child of the previous. So you can use the Hierarchy function to put the paths together. See this blog post for more information about Hierarchy: https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

[Yassine_Gh]

Hello ;

when I use the Hierarchy method for this dataset,
I have the impression that I have a bow that disappears.
Do you have an idea ?
Thank you

Num;Amont;Aval

1;1040;1039
2;1039;1040
3;1039;1038
4;1038;1039
5;1038;1107
6;1107;1038
7;1107;1037
8;1037;1107
9;1037;1031
10;1031;1037
11;1031;1036
12;1036;1031
13;1036;1035
14;1035;1036
15;1035;1034
16;1034;1035
17;1034;1033
18;1033;1034
19;1034;1052
20;1052;1034
21;1052;1033
22;1110;1052