6 Replies Latest reply: Sep 20, 2011 12:17 PM by saurabh desai RSS

    Select Field :Select child name and get all the children belong to that parent

    saurabh desai

      In Select Field , I want to select one child Name  C1 and in table box I would like to see all the children for the C1's parent.

       

      For example,

      Query in qlikview

       

      Children     Parent  ChildAge

      C1               p1      8

      C2                p1     10

      C3               p2       12

      C4                p1      5

      C5                p2      4

       

      Now , using select field , if I select C1 , I would like to see below result set in Tablebox or in other object control.

      Children      parent     ChildAge

      C1               p1                    8

      C2               p1                    10

      C4               p1                    5