Multiple colors in the same cell

[Joel Masciocchi]

Dear Tibco community,

I would like to know if there is a way to set multiple colors for the same cell.

I created a calculated column which is a concatenation of 3 different columns (A, B, C) and I would like to color this column using the 3 values based on 3 threshold (e.g. to have a color for the A value, a color for the B value and a color for the C values).

I am able to color the cell according to one of the value but the coloring is applied to the whole cell and not only to one value of the cell.

Regards,

Joel

[Fabian Duerr]

I don't think that this is possible. But why don't you just place your columns next to each other and color them individually This would have the same visual effect. And if you don't want to move your original columns you could still create copys of them.

[Joel Masciocchi]

Hi fabd

 

I concatenated columns to have a summary view instead of scrolling along the cross table which would be difficult to analyse, in case you have a huge number of columns.

 

Regards,

 

Joel

[Fabian Duerr]

I see. It wasn't clear from your initial request that you are talking about a cross table.

 

You could create a new data table with a pivot operation on your original table that holds the same info as your cross table. And there you could easily move your columns around or hide columns that you don't want to see.