I have one requirement .below example table is there.
Site
Parent/child
Parent number
1
Parent
-
2
Child
1
3
Parent
-
4
Child
1
5
Child
3
-The requirement is
We need(filter) site and detail information about site in qlik table.
If site selected is Parent then in the table we want all the child sites for the filter.
If selected site is Child then we want all the parent site and child site for the parent.
Ex:
if i select site 1(parent) it showing the table only child data like 2 ,4 because in that table 2,4 having parent code is1 .no need to show parent data.
if i select site 4(child) need to show parent details with child details.it showing 4 and 1.
