Calculate columns using List Box Multiple Select values

[Spencer Alexander]

Hi all,

I am using TIBCO Spotfire Analyst 10.0.0 HF-004, build version 10.0.0.98.

I have a List Box Multiple Select with values A, B, C, etc., which I am wanting to use in conjunction with some existing columns (colA, colB, colC, etc.) to create some calculated columns (calcColA, calcColB, calcColC, etc.). The calculated columns should behave such that: if A is selected in the List Box, calcColA is identical to colA, and otherwise, calcColA is empty. Similarly for the other calculated columns.

How can I do this

Thanks!

[Richard Pobi]

https://www.youtube.com/watchv=YahRu9KDdak

[Spencer Alexander]

Thanks, this video pointed me in the right direction. The expression I ended up using for calccolA was:

 

If(Find("A","${list_box_multiple_select_document_property_name}")>0, [colA])

 

Similarly for the other calculated columns. If there are name conflicts, they can be gotten around by changing the expressions in the list box multiple select to be different from the display values.