Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
koushik_btech20
Contributor

dependent code showing

suppose in member table , there are member id and memeber name, now member id suppose A237 01 , M23 01 etc where A237 01 is main member but A237 02, A37 03, A237 04 thse are dependent members of A237 01. So how can I display the dependent member after selecting the head member id.... if anyone have the solution plz share ....

1 Reply
Not applicable

Re: dependent code showing

Load MemberId, MemberName,

if(right(MemberId,2)='01', 'Parent', 'Child') as RelationShip

From Table.

Hope this helps.

Community Browser