Current Selections in Chart

[#1]

Hello Guys,

     I have a year field as a selection criteria in my sheet. As we all know, we can make multiple selections in a  list box.

     My problem is I need to display all the year values whatever selected in that list box.

     Can you mention any function for that?

Thanks & Regards,

RB

[kaushiknsolanki]

Hi,

   Use the function.

   GetFieldSelections(FieldName)

Regards,

Kaushik Solanki

[#3]

Hi Solanki,

     I know that function GetfieldSelections. It returns the value of last selections made. But what I need is, I want to represent the values of more than one selections in the caption of the chart.

     Let me explain you some more,

               I have the JoinYear as List box in a sheet. I have enabled chechboxes. So that I can make multiple Selections. Presently JoinYear field contains 4 unique values only. 2008-2011. If I selected 2008, 2009 and 2010(three years), then I want to display as 'Chart for FY08, FY09, FY10'.

     Please help me to solve this.

Thanks & Regards,

RB

[sathishkumar_go]

HI Bala,

Just try this

='FY' &GetFieldSelections(FieldName)

-Sathish

[#5 · Accepted solution]

Hi,

Use Concat() function,

Find attached sample document, hope this helps you in solving the problem.

[#6]

Hi Sathish,

     Thanks for your idea. But I have already done that. And Its showing the recently selected value even we made multiple selections. I dont need the recently selected single value. I want to display all the whatever selected in that list box.

[kaushiknsolanki]

Hi,

   Try this.

    ='Chart for ' &Concat('FY'&right(Year,2),' , ')

Regards,

Kaushik Solanki

[sathishkumar_go]

Hi,

I attached the Qvw Here.

I hope this ll help for u.

-Sathish

[#9]

Hi guys,

thanks a lot... I got the answer...