(cache)Use a multiple select list box to filter visualizations (or use in a calculated column)

For example you have a list box (multiple select) which contains multiple quarters. multiple_select1

By selecting one or multiple quarters the data table next to it has to be filtered.
multiple_select2

The trick is to switch the statement and use a regular expression because the user can select multiple items and the formula needs to be able to compare that. Go to you visualization properties and add the formula bolow to ‘Limit data using expression’.

"$map("${PropertyPeriod}", ",")" ~= [Period]

1	"$map("${PropertyPeriod}", ",")" ~= [Period]

find([Period], "$map("${PropertyPeriod}", ",")") > 0

1	find([Period], "$map("${PropertyPeriod}", ",")") > 0

Or if you want to show all when nothing is selected.

If(Len("$map("${PropertyPeriod}", ",")") > 0, "$map("${PropertyPeriod}", ",")" ~= [Period], true)

1	If(Len("$map("${PropertyPeriod}", ",")") > 0, "$map("${PropertyPeriod}", ",")" ~= [Period], true)

3 thoughts on “Use a multiple select list box to filter visualizations (or use in a calculated column)”

Hello,

in the second expression :
If(Len(“$map(“${PropertyPeriod}”, “,”)”) > 0, “$map(“${PropertyPeriod}”, “,”)” ~= [Period], true)

What’s &gt ?

I have not managed to run this expression… Could you provide more details on it ? I don’t understand how it works.

Thank you very much.

HTML was not translated, corrected it.
Should be ‘>’ symbol (bigger than).

Hello,

The first expression works well in the spotfire environment but when i try to run it in he web player it says “PROPERT CONTROL NEEDS TO BE CONFIGURED”.

Can you please help me on how to configure a property control?\

Thanks,
MS

Spotfire planet

TIBCO Spotfire tips and tricks

Use a multiple select list box to filter visualizations (or use in a calculated column)

3 thoughts on “Use a multiple select list box to filter visualizations (or use in a calculated column)”

Leave a Reply Cancel reply