topic Re: How to mark selected values in table? in QlikView

How to mark selected values in table?

ingoniclas — Sat, 16 Nov 2024 05:00:04 GMT

Hi,

I have a client who wants to see which values have been selected in the same table where the results are shown. Example: I have selected 'Company A' in the field 'Company' and 'Product B' in the field 'Product'. Now these two values should be marked or labeled e.g. by colouring the fields yellow. How can this be achieved?

Thanks,

Ingo

Re: How to mark selected values in table?

tresB — Tue, 11 Dec 2018 09:28:25 GMT

In the presentation tab of the chart properties, check 'Selection Indicators' like below:

The green dot beside Period field - means value(s) from the same field is selected.

Re: How to mark selected values in table?

ingoniclas — Tue, 11 Dec 2018 10:06:40 GMT

Thanks. But this is not what I'm looking for. The client wants to send the table to excel and see in this excel table the selected values.

Re: How to mark selected values in table?

tresB — Tue, 11 Dec 2018 10:16:50 GMT

You can use getcurrentselections() or getfieldselections() (or even the current selections object itself) to capture the selection information and put it in some object separately or in the same chart itself and then let the user export it. For better formatted user friendly solution, you might have to look for macro which is not a good proposal to consider.

Re: How to mark selected values in table?

ingoniclas — Tue, 11 Dec 2018 10:58:10 GMT

Thanks Babyface! getcurrentselections() will do the job!