Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use Concat() function,
Find attached sample document, hope this helps you in solving the problem.
Hi,
Use the function.
GetFieldSelections(FieldName)
Regards,
Kaushik Solanki
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
HI Bala,
Just try this
='FY' &GetFieldSelections(FieldName)
-Sathish
Hi,
Use Concat() function,
Find attached sample document, hope this helps you in solving the problem.
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.
Hi,
Try this.
='Chart for ' &Concat('FY'&right(Year,2),' , ')
Regards,
Kaushik Solanki
Hi,
I attached the Qvw Here.
I hope this ll help for u.
-Sathish
Hi guys,
thanks a lot... I got the answer...