Unique Concatenate FILTERED rows from a data table into cross tab title

[Brendan Law]

Using spotfire 7.8. I have a FILTERED data table (I'm using filters on the dataset)like below:

 

 

 

 

 

 

 

CstCtr

Amount

 

 

ab.123

9

 

 

cd.123

99

 

 

cd.123

8

 

 

ab.123

88

 

 

 

 

 

 

 

 

I would like to create a title for a cross tab vasualization that utilizes the field "CstCtr" to provide a unique string concatenation of all values in the field. The end result title would be:

"ab.123, cd.123"

Is there any way to do this

[Naveen Tibco]

Hello Brendanlaw,

 

if you want see the title of what we selected,,,

 

right click on CrossTable   ---> properties  --->General --> click on edit 

 

there you can change which column value we have to display in cross table title..

 

 

 

Thanks

 

Naveen

[Anders Gavare]

Perhaps someone on this forum has a nice expression or way of setting such a title.

If it is not possible to do it in a nice way, one can perhaps do it in a more involved way, by using R scripting (data functions). First, using data function 1, I would create a filtered data table containing the column you want to use (CstCtr), then add a regular calculated column in that intermediary table to get UniqueConcatenate() of that column, and finally, using data function 2, take the first value in that calculated column and put it in a document property which can be set as the title.

This involves two data functions, and thus may be a bit more involved than you were looking for. But it does seem to work. (Tried in Spotfire 7.14.)