Hi All,
Please find the below tables for my requirement.
let me know how I can achieve in Qliksense.
This is DB table
Diagram Number | Diagram Name |
1.1 | A |
1.2 | B |
1.3 | C |
1.4 | D |
1.10 | E |
1.11 | F |
1.1.1 | G |
1.1.2 | H |
1.1.11 | I |
1.2.1 | J |
1.2.5 | K |
1.2.15 | L |
1.10.1 | M |
1.10.10 | N |
1.11.1 | O |
1.11.5 | P |
1.11.20 | Q |
Output table should be
Level 1 | level2 |
A | G |
A | H |
A | I |
B | J |
B | K |
B | L |
E | M |
E | N |
F | O |
F | P |
F | Q |
with this level 1 and level 2 I need to create hierarchy.