I need a help regarding display of data in "text object" using expression.
I have the below data as a table box in Qlikview.
|India||Hritik Roshan||12,Broad Street,Mumbai||Credit Card|
|China||Cherry k Chen||44,Green Park, Bejing||Personal Loan|
|Hong Kong||Anthony O||65,Park Place,Hong Kong||Mortgage|
|Australia||Robert Methews||55,Rose Garden, Sydney||Mutual Fund|
I want to display the Customer Name , Address and Product in three different Text Box which would be linked to the above "Table box". For example if i click on a particular customer name in the "table Box" ,
1.the same customer name with appear in a text box
2.The corrosponding address of the selected customer will appear in a separate text box
3. The corrosponding product name will appear in the third text box.
I want the data to appear on dynamic basis.
I know that I need to write some expression in the text boxes to make it happen. Now I am confused and unable to write the correct expression.
If anyone can help..!