pass selected item as header

[#1]

There are two columns -- header and item -- in a table box chart.

If a user click an item and that item is one of the headers, how to pass the selected item as a header and let the table box show relevant contents as below example (assume E13 as item is selected)?

qvw is attached. Appreciate your kind advice.

[sunny_talwar]

The attached qvw has no data. Also do you want to see this in the table box or a straight table will work?

[settu_periasamy · Accepted solution]

Hi,

May be you can try with Triggers..

Document Properties -> Triggers -> Field Event Triggers -> Select In Field

Field :   headers

Search String:  =Only({<headers=P(Items),Items=>}headers)

[#4]

Hi settu,

thanks for the suggestion. have some problems to try the search string: =Only({<headers=P(Items),Items=>}headers)

it has error in set modifier element function. i'm not able to figure out what's wrong

[settu_periasamy]

Do you have same field which i proposed? It is case sensitive.

headers or Headers?

Items or items?

You need to give the exact name.

Can you post what you have done in qvw?

[#6]

Hi settu,

all fields are in lowercase. it works now!

MANY THANKS!