topic Re: Current Selections in Chart in QlikView

Current Selections in Chart

Tue, 05 Jul 2011 10:42:59 GMT

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,

Current Selections in Chart

kaushiknsolanki — Tue, 05 Jul 2011 10:51:25 GMT

Hi,

Use the function.

GetFieldSelections(FieldName)

Regards,

Kaushik Solanki

Current Selections in Chart

Tue, 05 Jul 2011 11:03:44 GMT

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,

Current Selections in Chart

sathishkumar_go — Tue, 05 Jul 2011 11:18:31 GMT

HI Bala,

Just try this

='FY' &GetFieldSelections(FieldName)

-Sathish

Re: Current Selections in Chart

Tue, 05 Jul 2011 11:28:00 GMT

Hi,

Use Concat() function,

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

Current Selections in Chart

Tue, 05 Jul 2011 11:29:56 GMT

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.

Re: Current Selections in Chart

kaushiknsolanki — Tue, 05 Jul 2011 11:31:09 GMT

Hi,

Try this.

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

Regards,

Kaushik Solanki

Re: Current Selections in Chart

sathishkumar_go — Tue, 05 Jul 2011 11:52:42 GMT

Hi,

I attached the Qvw Here.

I hope this ll help for u.

-Sathish

Current Selections in Chart

Tue, 05 Jul 2011 12:03:57 GMT

Hi guys,

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