From J Wiki
Jump to: navigation, search
J6/Grid | Data Options Types | Actions Events Methods | Class DerivedClass | Hierarchical MultiDimensional MultiLine Virtual | Examples

A multidimensional grid displays multidimensional numeric arrays. Each axis may appear in the rows, or columns, or as a slice through the data. The display may be rearranged by drag and drop, or by selecting a new slice.


In the grid display, the rows and columns are shown at bottom left and top right. At top left are any slices through the data.


Drag and drop an axis tile to rearrange the cube, or click a slice to select a new value.


New Options

A new option group AXIS defines a multidimensional grid.

AXISLABELS axis labels
AXISNAMES axis names
AXISORDER axis order

AXISLABELS - A list of lists, one for each axis. The length of the labels must match the data.

AXISNAMES - A list of names, one for for each axis.

AXISORDER - The axis ordering for the initial display, as a list of 3 or 4 elements:


where rws is the row axes, cls is the column axes, sel is the sliced axes, and the optional selindex is the corresponding indices for sel.

Other Options

CELLDATA should be a numeric array, with shape matching AXISNAMES and AXISLABELS.

CELLFMT may only be a single format, i.e. same for each cell.



The following example is shown above, and also in demo Studio|Demos|Grid|Multi-Dimensional.

a0=. ;: 'Ford GM Honda Toyota Total'
a1=. '2006';'2007'
a2=. ;: 'Hire Lease Sale'
a3=. ;: 'CA KS MN NY TX'
a4=. <;._1 '/Compact/Standard/Full Size/Luxury/MiniVan/SUV/Total'
AXISLABELS=: a0;a1;a2;a3;<a4
AXISNAMES=: ;: 'Model Year Finance State Group'
AXISORDER=: 0;1 2;3 4;0 2
d=. 3 + ?. 17 $~ _1 0 0 0 _1 + # &> AXISLABELS
CELLDATA=: d,"1 0 +/"1 d=. d,"5 4 +/"5 d