Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you do a search in a listbox e.g. 1* , which returns all values that start with '1' ,
getfieldselections(FIELD , ',' , 20000)
will return '1*' and not the selected values of FIELD, even if the number of selection is below the parameter 20000.
If you do the same selection via a visualization object like a barchart with the dimension
aggr(left(FIELD,1),FIELD)
and the measure
count(distinct FIELD) ,
getfieldselections(FIELD , ',' , 20000) will return a proper comma separated list.
How can we see the selection as a list, if the selection is made via a placeholder search?
Try using the concat() function like this:
if(getselectedcount([Field])>0,concat(distinct [Field],','))
I'm not sure of the max length limitation. How do you plan to use/display the results?
You can use the count function to control what happens if a large number of values would be returned.