How to get the filter pane value dynamically in a variable

[Anonymous]

Hi,

I have a field as [Date ID], I have created a filter pane (Same as list box) as 'year([Date ID])'. Now when a value is selected from the filter pane, I want to show the selected value to the title of the charts. Can I catch the selected value in a variable? Please help if there is any function to do that.

[lorenzoconforti]

Something like this in the title field:

=Concat(distinct year([Date ID]),',')

regarding the variable, can you please explain what you are trying to achieve?

[hallquist_nate]

You should be able to use the function GetCurrentSelected() to capture that value.

Have you looked at that?

Nate

[Anil_Babu_Samineni]

Yes, You can.

=Concat([Date ID], '-')

[Anonymous]

Yes, I have checked with GetCurrentSelections() function. In my example it is showing both the field and the selected value as Year(Date ID) : 2017.

I only want to show 2017, the selected value

[Anil_Babu_Samineni]

Then Work like this?

SubField(GetCurrentSelections(), ' ', -1)

[isingh30]

Please attach your document.

Thanks.

[sasikanth]

HI ,

try below if you want to show only single value.

& max(Year([Date ID]))  along with chart tittle

Ex:

sales by customer for & max(Year([Date ID]))