Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
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.

View solution in original post

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

Highlighted
Creator II
Creator II

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.

Highlighted
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.

View solution in original post

Highlighted
Creator II
Creator II

Re: How to mark selected values in table?

Thanks Babyface! getcurrentselections() will do the job!