topic Re: pass selected item as header in QlikView

pass selected item as header

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: pass selected item as header

sunny_talwar — Mon, 21 Mar 2016 09:46:27 GMT

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

Re: pass selected item as header

settu_periasamy — Mon, 21 Mar 2016 10:08:14 GMT

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)

Re: pass selected item as header

Wed, 23 Mar 2016 02:20:07 GMT

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

Re: pass selected item as header

settu_periasamy — Wed, 23 Mar 2016 08:41:28 GMT

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?

Re: pass selected item as header

Thu, 24 Mar 2016 08:35:22 GMT

Hi settu,

all fields are in lowercase. it works now!

MANY THANKS!