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’.

or

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

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

  1. 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.

  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

2 + 1 =