Skip to Content
avatar image
Former Member

How to pass ListBox values to the datasource

Hi Expert,

I have list box and chart/crosstab. Based on my selection in listbox the values have to change in the graph/cross tab

On "Start up" i have below code which populate the values in the list box

var values=DS_1.getMemberList("_kZ3abwXPEeePdcwFKyYXrQ", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 500); LISTBOX_1.setItems(values);

in "On Select" of list box, i have below code to filter the crosstab/data source.

DS_1.setFilterExt("_kZ3abwXPEeePdcwFKyYXrQ", LISTBOX_1.getSelectedValues());

but i am getting error "Cannot convert from string array to input string".

What i am doing wrong here, How i make this work?

I know the problem is multi value, i need multi selection.

Any help, much appreciated.

Thanks

VJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 25, 2017 at 01:53 AM

    Hi VJ,

    You should make the following changes to your code:

    1. Use INTERNAL_KEY instead of EXTERNAL_KEY

    var values=DS_1.getMemberList("_kZ3abwXPEeePdcwFKyYXrQ", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 500); LISTBOX_1.setItems(values);
    

    2. Use setFilter() instead of setFilterExt() in "On Select" event script of the List Box

    DS_1.setFilter("_kZ3abwXPEeePdcwFKyYXrQ", me.getSelectedValues());

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded