Need urgent help - for showing associated field details

[ananyaghosh]

Hi,

Please refer the below image where I have to show the details of a sales representatives. I have a list of a sales representatives in table and I want that when one Sales representatives name is selected, the details of that person will be shown as below:

Please can anyone suggest that how can got the values of that person and show values related to him into a another sheet?

Thanks,

Sandip

[adamdavi3s]

This is how qlikview works?

If you select a person then as long as the detail works then any related values should show.

You might need to expand on your exact issue a bit!

[ananyaghosh]

Hi,

I have the following data model: Now I have table with Customer Id and Customer Name. My requirement is when I will select the customer id from the table, it will reflect the all related details of customer id in a text box like that:

Table images is here:

and Text box information will be as follows:

Thanks,

Sandip

[adamdavi3s · Accepted solution]

Ok so try something like

='Customer Id = '&CustomerID&chr(13)&' Customer Name ='&CustomerName

chr(13) is a carriage return so makes a new line