For example you have a list box (multiple select) which contains multiple quarters.
By selecting one or multiple quarters the data table next to it has to be filtered.
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’.
|
1 |
"$map("${PropertyPeriod}", ",")" ~= [Period] |
or
|
1 |
find([Period], "$map("${PropertyPeriod}", ",")") > 0 |
Or if you want to show all when nothing is selected.
|
1 |
If(Len("$map("${PropertyPeriod}", ",")") > 0, "$map("${PropertyPeriod}", ",")" ~= [Period], true) |
Hello,
in the second expression :
If(Len(“$map(“${PropertyPeriod}”, “,”)”) > 0, “$map(“${PropertyPeriod}”, “,”)” ~= [Period], true)
What’s > ?
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