I need a help regarding display of data in "text object" using expression.
I have the below data as a table box in Qlikview.
Country
Customer Name
Address
Product
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.
