topic dependent code showing in QlikView https://community.qlik.com/t5/QlikView/dependent-code-showing/m-p/424292#M697485 <HTML><HEAD></HEAD><BODY><P>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 ....</P></BODY></HTML> Fri, 08 Mar 2013 18:40:16 GMT koushik_btech20 2013-03-08T18:40:16Z dependent code showing https://community.qlik.com/t5/QlikView/dependent-code-showing/m-p/424292#M697485 <HTML><HEAD></HEAD><BODY><P>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 ....</P></BODY></HTML> Fri, 08 Mar 2013 18:40:16 GMT https://community.qlik.com/t5/QlikView/dependent-code-showing/m-p/424292#M697485 koushik_btech20 2013-03-08T18:40:16Z Re: dependent code showing https://community.qlik.com/t5/QlikView/dependent-code-showing/m-p/424293#M697487 <HTML><HEAD></HEAD><BODY><P>Load MemberId, MemberName,</P><P>if(right(MemberId,2)='01', 'Parent', 'Child') as RelationShip</P><P></P><P>From Table.</P><P></P><P>Hope this helps.</P></BODY></HTML> Sat, 09 Mar 2013 11:51:35 GMT https://community.qlik.com/t5/QlikView/dependent-code-showing/m-p/424293#M697487 2013-03-09T11:51:35Z