Select value from customer listbox

[Anonymous]

Hi gurus

i have a customer listbox let say

valuelist(1,2,3,4,5)

how to get the value from this customer listbox in text object ?

thanks

[marcus_sommer]

If you have a real field you could get these values per concat() or getfieldselections() - by using such a calculated dimension without a connection to the datamodel I don't think it will be possible. Maybe if you elaborate it a bit more thereare other ways to reach your aim.

- Marcus

[Anonymous]

Hi Marcus,

let say i have a listbox with express : Valuelist(1,2,3,4,5), then once user click on 1, then

the pivot table will take this as a parameter ,  so the table express will

10 *  <Value select from the listbox>

Can do it without load script ??

Thank you for your help

[marcus_sommer · Accepted solution]

If you instead of the valuelist() takes the content of a small inline table for the listbox, like:

load * inline [

F2

1

2

3

];

you could easily refer to those selections, for example:

sum({< F1 = p(F2) >} AnyValue)

Another approach would be to use a variable within an inputbox (maybe with predefined values in a dropdown) to which your pivot could refer - but to a valuelist() I don't know any way.

- Marcus