Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ingoniclas
Contributor

How to mark selected values in table?

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

1 Solution

Accepted Solutions
MVP
MVP

Re: How to mark selected values in table?

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.
4 Replies
MVP
MVP

Re: How to mark selected values in table?

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

Capture.JPG

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

ingoniclas
Contributor

Re: How to mark selected values in table?

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.

MVP
MVP

Re: How to mark selected values in table?

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.
ingoniclas
Contributor

Re: How to mark selected values in table?

Thanks Babyface! getcurrentselections() will do the job!