Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

Ah yes, another moving target....

Maybe like attached?

You'll need to first select a child in children listbox, then press the button, the table box is populated with children of same parent. It's an input field, you can modify the child (Not sure if this makes sense, but you will know).

Regards,

Stefan

6 Replies
MVP
MVP

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

Hi programmer123,

maybe like attached?

I just used a straight table with dimensions children and parent and this as expression:

=sum({<Children=p({1<Parent=p(Parent) >}) >} ChildAge)

Regards,

Stefan

Not applicable

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

Hi Swuehl,

your answer is helpful, but my exact requirement is

1) In Select fields ,I will display the list of : Children, and from the list I will  select one children element

Now , i should be able to capture the parent of the selected child and then would be able to find all the children for that parent

2) In table box , I  would be able to see the children list of the parent.(i would like to see this in table box, not in staright table)

so for example,

In select field , if i select children  C1,  table box should display the data like below.

Children parent ChildAge

C1          p1          8

C2          p1          10

C4          p1          5

3) Once the data displayed in table box, i will use input field on children field in table box and then i will modify the input field value and those changes should be reflected on Chart.Chart should display data based on TableBox

I hope you understand!!!!

MVP
MVP

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

Ah yes, another moving target....

Maybe like attached?

You'll need to first select a child in children listbox, then press the button, the table box is populated with children of same parent. It's an input field, you can modify the child (Not sure if this makes sense, but you will know).

Regards,

Stefan

Not applicable

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

Hi Swuehl,

thx fro help!!  i dont have Licence version, can you pls send me the steps !!! sorry for giving extra unncessary trouble

MVP
MVP

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

Hi,

I am on road so just trying to remember:

Create a button with action Select - type Select in fields.

Field is plain

Children

Search expression is

='=sum (...)'

where you use the sum as given above.

Use an inputfield statement in the script.

Regards,

Stefan

Not applicable

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

HI  Swuehl,

Thanks for reply!!! your answer works...