how to fix the Column width in Cross table when we have a hierarchy-slider as an axis.

[deepu Shrestha]

I have a cross table that provides aggregated data for the given Hiearchy.

As I slide the Hierarchy the column width for the columns in the hierarchy is not fixed and the data is not displayed completly.

[Mary DeMange]

Did you get an answer to this Because I'd sure like to get the column width to be fixed too. It appears that the hierarchy width stays intact with graphical tables but not cross tables.

 

 

[K Clark]

Still waiting for an answer to thie question - - Any luck

[Gerald Emesih 5]

I had the same problem. Here are the steps I took to fix the problem:

a) I set up a dropdown property control (Hier) with fixed values (0,1,2) to assign the levels of my hierarchy

b) Modified the custom expression on the visualization axis to use the property Control (Hier)

c) Added an action to Execute the following script when the property control changes:

#ct is a cross table vis script param

#Period is a script parameter with a value pointing to the (Hier) property control value

from Spotfire.Dxp.Application.Visuals import CrossTablePlot

crossTable = ct.As[CrossTablePlot]()

#in my case I had Year, Qtr,Month ... set the width of the selected level to be fixed

#set the rowHeaderWidth for the next description columns higher

crossTable.RowHeaderWidths[Period]=80

crossTable.RowHeaderWidths[Period + 1]=300

 

Hope this helps!

Gerald Emesih