Picker functionality

[Former Member]

Hi All,

We have a requirement where in we have to pick some values clicking on a picker button.

After clicking on picker button a new small window should open from where user can pick the values. After choosing any value it should disappear. (screenshot attached below).

Can anyone please guide me in detail to achieve this, I tried with dynamic visibility but failed.

Thanks,

Vennela.

[former_member182541 · Accepted solution]

Check out the attached file.

DV.txt.zip

[Former Member · Accepted solution]

Hi Suman,

Thanks for the file. My problem solved.

[Former Member · Accepted solution]

Hi Suman,

Need one more help on this. Could you please let me know if we can select  more than one value from the list view?

For ex: as per the screenshot attached, I selected the item "After Market Services" and passing it to the label above it(picker). So can I select multiple items at a time and pass it to the picker?

Is there any way to achieve this?

Thanks,
Vennela

[former_member182541 · Accepted solution]

Multiple selection cannot be done through list view. It can be done only through list builder.

This is a limitation with dashboard. Not sure but you can try with some third party component which can help you on this.

http://visualbi.com/blogs/custom-component/multi-select-combo-box-sap-dashboards-xcelsius/

http://visualbi.com/blogs/custom-component/multi-select-list-box-for-sap-businessobjects-dashboards-...

More selectors that support multiple selections : View Idea

[Former Member · Accepted solution]

Thank you suman for all the information.

[vijaymuniraj]

Hi,

What if you place a push button on right side corner of window to close it once you selected the desired values?

if above is not in scope, let me know what are the values you will select once window is appeared? Why i'm asking if it is limited number of values, we can do some work around.

Thanks

[Former Member]

Hi Vijai,

I would like to pick a value from the window that appeared.

Eg: In the screenshot I attached, Product category is a filter parameter, I want to choose a value for that by picking a value from the window appeared below.

What I would like to know is to control the window dynamically. i.e. clicking on the picker it should open the window and close it after selecting a value.

Thanks

Vijay.

[Former Member]

Hi,

Have a toggle button (transparent) on the picker and display the selection window once you click the picker. And use Push button to close after selection is made.

[vijaymuniraj]

So my understanding is, if you click any row on the table, the window should disappear. Is that correct?

[vijaymuniraj]

Hi,

Assuming that you have used scorecard and filter rows option to filter the Prodcut category. If yes, just map one more column with source. ex:- refer the below screen. If your source is from Cell B6 to E11, just hard code value 1 on column F as you see in below pic. Now if you refer cell F15, 1 is passed to destination (once it is filtered on score card). Now you can use cell F15 for dynamic visibility to pass 0 from picker button to display window and after if you filter any value on scorecard, value 1 will be passed to F15 and window will disappear.

Thanks

[Former Member]

Hi Vijai,

Thanks for your reply . I am not using scorecard, just populating the list view with a query.

[Former Member]

Hi,

Can you please tell what exactly the problem you are facing here in acheiving this?

[Former Member]

Hi,

I am trying to show the window dynamically upon clicking on the picker and after choosing any value from the window it should close.

I would like to know how to make the window visible dynamically upon clicking the picker, same as choosing a date from a calendar.

Thanks,

Vennela.

[Former Member]

Hi,

Have a push button and rename it as close or "X" so that it looks like a close button. map it to a cell that has 0. then upon every click it will write 0 into a cell. map that cell to the scorecard on which you are making selection. Hence whenever you make selections and click on push button the selection window closes.