Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Current Selections in Chart

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

1 Solution

Accepted Solutions
Not applicable

Re: Current Selections in Chart

Hi,

Use Concat() function,

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

8 Replies

Current Selections in Chart

Hi,

   Use the function.

   GetFieldSelections(FieldName)

Regards,

Kaushik Solanki

Not applicable

Current Selections in Chart

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
Contributor III

Current Selections in Chart

HI Bala,

Just try this

='FY' &GetFieldSelections(FieldName)

-Sathish

Not applicable

Re: Current Selections in Chart

Hi,

Use Concat() function,

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

Not applicable

Current Selections in Chart

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

Hi,

   Try this.

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

Regards,

Kaushik Solanki

sathishkumar_go
Contributor III

Re: Current Selections in Chart

Hi,

I attached the Qvw Here.

I hope this ll help for u.

-Sathish

Not applicable

Current Selections in Chart

Hi guys,

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

Community Browser