Revision as of 09:49, 7 December 2015

FixedCrossTable

A resource journal entry

Constructors

(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", FixedCrossTableRowSeries rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 1x0 FixedCrossTable.
(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", array secondaryRowAxis "Axis from Axis_xxx function for the secondary row axis.", array rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 2x0 FixedCrossTable.
(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", string colTitle "Title of column.", array primaryColAxis "Axis from Axis_xxx function for the primary column axis.", array rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 1x1 FixedCrossTable.
(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", string colTitle "Title of column.", array primaryColAxis "Axis from Axis_xxx function for the primary column axis.", array secondaryColAxis "Axis from Axis_xxx function for the secondary column axis.", FixedCrossTableRowSeries rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 1x2 FixedCrossTable.
(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", array secondaryRowAxis "Axis from Axis_xxx function for the secondary row axis.", string colTitle "Title of column.", array primaryColAxis "Axis from Axis_xxx function for the primary column axis.", array rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 2x1 FixedCrossTable.
(string rowTitle "Title of row.", array primaryRowAxis "Axis from Axis_xxx function for the primary row axis.", array secondaryRowAxis "Axis from Axis_xxx function for the secondary row axis.", string colTitle "Title of column.", array primaryColAxis "Axis from Axis_xxx function for the primary column axis.", array secondaryColAxis "Axis from Axis_xxx function for the secondary column axis.", array rowSeries "Data for the table.", array statisticsValues "Array of StatisticsItems.") - Create new 2x2 FixedCrossTable.

Methods

string ToString() - The string representation of the object.

Properties

string ObjectTypeName { get; } - The name of the type of object.
TypeInformation TypeInformation { get; } - Get information about this class.

Examples For Table 1x0

DCS_use(12344983);

// Get Axis:
array axisNew = Axis_new("LuuTest");
axisNew[AXIS_TEXT] = "Choose a D_Week";

// Init:
FixedCrossTableRowSeries rowseries;
FixedCrossTableDataSeries dataserie;
FixedCrossTableDataItem dataItemAbs;
FixedCrossTableDataItem dataItemPct;
// Set up a table
// table 1x0
rowseries = new FixedCrossTableRowSeries();
dataserie = new FixedCrossTableDataSeries();
number count;
number countTotal = count() where D_Week != empty;

for(number i = 201301; i < 201305; i++)
{
 Axis_addOption(axisNew, AxisOption_new("Week " + i.ToString(), ""));
 
 count = count() where D_Week == i;
 dataItemAbs = new FixedCrossTableDataItem();
 dataItemAbs.Value = count;
 dataItemPct = new FixedCrossTableDataItem();
 dataItemPct.Value = count*100/countTotal;
 dataserie.Add(dataItemAbs,dataItemPct);
}
// other
Axis_addOption(axisNew, AxisOption_new("Week Other", ""));
count = count() where D_Week != [201301-201304] && D_Week != empty;

dataItemAbs = new FixedCrossTableDataItem();
dataItemAbs.Value = count;
dataItemPct = new FixedCrossTableDataItem();
dataItemPct.Value = count*100/countTotal;
dataserie.Add(dataItemAbs,dataItemPct);

dataserie.AbsoluteTotal.Value = countTotal;
dataserie.PercentageTotal.Value = countTotal*100/countTotal;

rowseries.Add(dataserie);
FixedCrossTable table1x0 = new FixedCrossTable("Create by createFixedCrossDiagram - D_Week", axisNew , rowseries, empty);
// genarate table:
createFixedCrossDiagram(table1x0);

Result:

Examples For Table 2x1

DCS_use(15517112);

// Get Axis:
array axisRowPrimary = Axis_new("LuuTest1");
axisRowPrimary[AXIS_TEXT] = "Gender test";
Axis_addOption(axisRowPrimary, AxisOption_new("Mand", ""));
Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", ""));
array axisRowSecond = Axis_new("LuuTest2");
axisRowSecond[AXIS_TEXT] = "Region test";
Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", ""));
Axis_addOption(axisRowSecond, AxisOption_new("Other Region", ""));

array axisColPrimary = Axis_new("LuuTest3");
axisColPrimary[AXIS_TEXT] = "Week test";
Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", ""));
Axis_addOption(axisColPrimary, AxisOption_new("Year Other", ""));


array arrRowseries ={};
number count;
FixedCrossTableRowSeries rowseries;
FixedCrossTableDataItem dataItemAbs;
FixedCrossTableDataSeries dataserie;

dataserie = new FixedCrossTableDataSeries();

dataItemAbs = new FixedCrossTableDataItem();
dataItemAbs.Value = 1;
dataserie.Add(dataItemAbs,dataItemAbs);
dataserie.Add(dataItemAbs,dataItemAbs);
dataserie.AbsoluteTotal.Value = 1;
dataserie.PercentageTotal.Value = 1;

rowseries.Add(dataserie);
rowseries.Add(dataserie);

arrRowseries = {rowseries,rowseries,rowseries};

FixedCrossTable table2x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, arrRowseries, empty);
// genarate table:
createFixedCrossDiagram(table2x1);
createCrossDiagram({"Gender","Region"},{"D_Week"});

Result:

Examples For Table 2x2

DCS_use(15517112);

// Get Axis:
array axisRowPrimary = Axis_new("LuuTest1");
axisRowPrimary[AXIS_TEXT] = "Gender test";
Axis_addOption(axisRowPrimary, AxisOption_new("Mand", ""));
Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", ""));
array axisRowSecond = Axis_new("LuuTest2");
axisRowSecond[AXIS_TEXT] = "Region test";
Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", ""));
Axis_addOption(axisRowSecond, AxisOption_new("Other Region", ""));

array axisColPrimary = Axis_new("LuuTest3");
axisColPrimary[AXIS_TEXT] = "Week test";
Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", ""));
Axis_addOption(axisColPrimary, AxisOption_new("Year Other", ""));

array axisColSecond = Axis_new("LuuTest4");
axisColSecond[AXIS_TEXT] = "Age Group test";
Axis_addOption(axisColSecond, AxisOption_new("Year 2014", ""));
Axis_addOption(axisColSecond, AxisOption_new("Year Other", ""));

array arrRowseries ={};
number count;
FixedCrossTableRowSeries rowseries;
FixedCrossTableDataItem dataItemAbs;
FixedCrossTableDataSeries dataserie;

dataserie = new FixedCrossTableDataSeries();

dataItemAbs = new FixedCrossTableDataItem();
dataItemAbs.Value = 1;
dataserie.Add(dataItemAbs,dataItemAbs);
dataserie.Add(dataItemAbs,dataItemAbs);
dataserie.AbsoluteTotal.Value = 1;
dataserie.PercentageTotal.Value = 1;

rowseries.Add(dataserie);
rowseries.Add(dataserie);

arrRowseries = {rowseries,rowseries,rowseries,rowseries,rowseries,rowseries};

FixedCrossTable table2x2 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, axisColSecond, arrRowseries, empty);
// genarate table:
createFixedCrossDiagram(table2x2);

Result:

Difference between revisions of "FixedCrossTable class"

Revision as of 09:49, 7 December 2015

FixedCrossTable

Constructors

Methods

Properties

Examples For Table 1x0

Examples For Table 2x1

Examples For Table 2x2

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Categories

Tools

@@ Line 1: / Line 1: @@
-<p><span class="fck_mw_template">{{CGscriptClass_TemplatefckLR|Name=<nowiki>FixedCrossTable</nowiki>fckLR|Description=<nowiki>A resource journal entry</nowiki>fckLR|Constructors=fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 1x0 FixedCrossTable.</nowiki>}}fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>secondaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the secondary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 2x0 FixedCrossTable.</nowiki>}}fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>colTitle</nowiki>|Description=<nowiki>Title of column.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 1x1 FixedCrossTable.</nowiki>}}fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>colTitle</nowiki>|Description=<nowiki>Title of column.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>secondaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the secondary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 1x2 FixedCrossTable.</nowiki>}}fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>secondaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the secondary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>colTitle</nowiki>|Description=<nowiki>Title of column.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 2x1 FixedCrossTable.</nowiki>}}fckLR{{CGscriptConstructors_Template|Parameters=fckLR{{CGscriptParameters_Template|Type=string|Name=<nowiki>rowTitle</nowiki>|Description=<nowiki>Title of row.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>secondaryRowAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the secondary row axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>colTitle</nowiki>|Description=<nowiki>Title of column.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>primaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the primary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>secondaryColAxis</nowiki>|Description=<nowiki>Axis from Axis_xxx function for the secondary column axis.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>rowSeries</nowiki>|Description=<nowiki>Data for the table.</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=<nowiki>statisticsValues</nowiki>|Description=<nowiki>Array of StatisticsItems.</nowiki>}}fckLR|Description=<nowiki>Create new 2x2 FixedCrossTable.</nowiki>}}fckLR|Methods=fckLR{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Description=<nowiki>The string representation of the object.</nowiki>}}fckLR|Properties=fckLR{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}fckLR{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Description=<nowiki>Get information about this class.</nowiki>}}fckLR}}</span>
+{{CGscriptClass_Template
-</p>
+|Name=FixedCrossTable
-<h3> Examples For Table 1x0</h3>
+|Description=A resource journal entry
-<p><span class="fck_mw_source" _fck_mw_customtag="true" _fck_mw_tagname="source" lang="javascript">fckLRDCS_use(12344983);fckLRfckLR// Get Axis:fckLRarray axisNew = Axis_new(&quot;LuuTest&quot;);fckLRaxisNew[AXIS_TEXT] = &quot;Choose a D_Week&quot;;fckLRfckLR// Init:fckLRFixedCrossTableRowSeries rowseries;fckLRFixedCrossTableDataSeries dataserie;fckLRFixedCrossTableDataItem dataItemAbs;fckLRFixedCrossTableDataItem dataItemPct;fckLR// Set up a tablefckLR// table 1x0fckLRrowseries = new FixedCrossTableRowSeries();fckLRdataserie = new FixedCrossTableDataSeries();fckLRnumber count;fckLRnumber countTotal = count() where D_Week != empty;fckLRfckLRfor(number i = 201301; i &lt; 201305; i++)fckLR{fckLR	Axis_addOption(axisNew, AxisOption_new(&quot;Week &quot; + i.ToString(), &quot;&quot;));fckLR	fckLR	count = count() where D_Week == i;fckLR	dataItemAbs = new FixedCrossTableDataItem();fckLR	dataItemAbs.Value = count;fckLR	dataItemPct = new FixedCrossTableDataItem();fckLR	dataItemPct.Value = count*100/countTotal;fckLR	dataserie.Add(dataItemAbs,dataItemPct);fckLR}fckLR// otherfckLRAxis_addOption(axisNew, AxisOption_new(&quot;Week Other&quot;, &quot;&quot;));fckLRcount = count() where D_Week != [201301-201304] &amp;&amp; D_Week != empty;fckLRfckLRdataItemAbs = new FixedCrossTableDataItem();fckLRdataItemAbs.Value = count;fckLRdataItemPct = new FixedCrossTableDataItem();fckLRdataItemPct.Value = count*100/countTotal;fckLRdataserie.Add(dataItemAbs,dataItemPct);fckLRfckLRdataserie.AbsoluteTotal.Value = countTotal;fckLRdataserie.PercentageTotal.Value = countTotal*100/countTotal;fckLRfckLRrowseries.Add(dataserie);fckLRFixedCrossTable table1x0 = new FixedCrossTable(&quot;Create by createFixedCrossDiagram - D_Week&quot;, axisNew , rowseries, empty);fckLR// genarate table:fckLRcreateFixedCrossDiagram(table1x0);fckLR</span>
+|Constructors=
-Result:
+{{CGscriptConstructors_Template|Parameters=
-<br />
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
-<img src="/images/a/ad/Table1x0.png" _fck_mw_filename="Table1x0.png" alt="" />
+|Description=Create new 1x0 FixedCrossTable.}}
-</p>
+{{CGscriptConstructors_Template|Parameters=
-<h3> Examples For Table 2x1 </h3>
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
-<p><span class="fck_mw_source" _fck_mw_customtag="true" _fck_mw_tagname="source" lang="javascript">fckLRfckLRDCS_use(15517112);fckLRfckLR// Get Axis:fckLRarray axisRowPrimary = Axis_new(&quot;LuuTest1&quot;);fckLRaxisRowPrimary[AXIS_TEXT] = &quot;Gender test&quot;;fckLRAxis_addOption(axisRowPrimary, AxisOption_new(&quot;Mand&quot;, &quot;&quot;));fckLRAxis_addOption(axisRowPrimary, AxisOption_new(&quot;Kvinde&quot;, &quot;&quot;));fckLRarray axisRowSecond = Axis_new(&quot;LuuTest2&quot;);fckLRaxisRowSecond[AXIS_TEXT] = &quot;Region test&quot;;fckLRAxis_addOption(axisRowSecond, AxisOption_new(&quot;Region Hovedstaden&quot;, &quot;&quot;));fckLRAxis_addOption(axisRowSecond, AxisOption_new(&quot;Other Region&quot;, &quot;&quot;));fckLRfckLRarray axisColPrimary = Axis_new(&quot;LuuTest3&quot;);fckLRaxisColPrimary[AXIS_TEXT] = &quot;Week test&quot;;fckLRAxis_addOption(axisColPrimary, AxisOption_new(&quot;Year 2014&quot;, &quot;&quot;));fckLRAxis_addOption(axisColPrimary, AxisOption_new(&quot;Year Other&quot;, &quot;&quot;));fckLRfckLRfckLRarray arrRowseries ={};fckLRnumber count;fckLRFixedCrossTableRowSeries rowseries;fckLRFixedCrossTableDataItem dataItemAbs;fckLRFixedCrossTableDataSeries dataserie;fckLRfckLRdataserie = new FixedCrossTableDataSeries();fckLRfckLRdataItemAbs = new FixedCrossTableDataItem();fckLRdataItemAbs.Value = 1;fckLRdataserie.Add(dataItemAbs,dataItemAbs);fckLRdataserie.Add(dataItemAbs,dataItemAbs);fckLRdataserie.AbsoluteTotal.Value = 1;fckLRdataserie.PercentageTotal.Value = 1;fckLRfckLRrowseries.Add(dataserie);fckLRrowseries.Add(dataserie);fckLRfckLRarrRowseries = {rowseries,rowseries,rowseries};fckLRfckLRFixedCrossTable table2x1 = new FixedCrossTable(&quot;Create by createFixedCrossDiagram &quot;, axisRowPrimary, axisRowSecond,&quot;Column title&quot;, axisColPrimary, arrRowseries, empty);fckLR// genarate table:fckLRcreateFixedCrossDiagram(table2x1);fckLRcreateCrossDiagram({&quot;Gender&quot;,&quot;Region&quot;},{&quot;D_Week&quot;});fckLR</span>
+|Description=Create new 2x0 FixedCrossTable.}}
-Result:
+{{CGscriptConstructors_Template|Parameters=
-<br />
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
-<img src="/images/2/23/Table2x1.png" _fck_mw_filename="Table2x1.png" alt="" />
+|Description=Create new 1x1 FixedCrossTable.}}
-</p><p><br />
+{{CGscriptConstructors_Template|Parameters=
-</p>
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
-<h3> Examples For Table 2x2 </h3>
+|Description=Create new 1x2 FixedCrossTable.}}
-<p><span class="fck_mw_source" _fck_mw_customtag="true" _fck_mw_tagname="source" lang="javascript">fckLRDCS_use(15517112);fckLRfckLR// Get Axis:fckLRarray axisRowPrimary = Axis_new(&quot;LuuTest1&quot;);fckLRaxisRowPrimary[AXIS_TEXT] = &quot;Gender test&quot;;fckLRAxis_addOption(axisRowPrimary, AxisOption_new(&quot;Mand&quot;, &quot;&quot;));fckLRAxis_addOption(axisRowPrimary, AxisOption_new(&quot;Kvinde&quot;, &quot;&quot;));fckLRarray axisRowSecond = Axis_new(&quot;LuuTest2&quot;);fckLRaxisRowSecond[AXIS_TEXT] = &quot;Region test&quot;;fckLRAxis_addOption(axisRowSecond, AxisOption_new(&quot;Region Hovedstaden&quot;, &quot;&quot;));fckLRAxis_addOption(axisRowSecond, AxisOption_new(&quot;Other Region&quot;, &quot;&quot;));fckLRfckLRarray axisColPrimary = Axis_new(&quot;LuuTest3&quot;);fckLRaxisColPrimary[AXIS_TEXT] = &quot;Week test&quot;;fckLRAxis_addOption(axisColPrimary, AxisOption_new(&quot;Year 2014&quot;, &quot;&quot;));fckLRAxis_addOption(axisColPrimary, AxisOption_new(&quot;Year Other&quot;, &quot;&quot;));fckLRfckLRarray axisColSecond = Axis_new(&quot;LuuTest4&quot;);fckLRaxisColSecond[AXIS_TEXT] = &quot;Age Group test&quot;;fckLRAxis_addOption(axisColSecond, AxisOption_new(&quot;Year 2014&quot;, &quot;&quot;));fckLRAxis_addOption(axisColSecond, AxisOption_new(&quot;Year Other&quot;, &quot;&quot;));fckLRfckLRarray arrRowseries ={};fckLRnumber count;fckLRFixedCrossTableRowSeries rowseries;fckLRFixedCrossTableDataItem dataItemAbs;fckLRFixedCrossTableDataSeries dataserie;fckLRfckLRdataserie = new FixedCrossTableDataSeries();fckLRfckLRdataItemAbs = new FixedCrossTableDataItem();fckLRdataItemAbs.Value = 1;fckLRdataserie.Add(dataItemAbs,dataItemAbs);fckLRdataserie.Add(dataItemAbs,dataItemAbs);fckLRdataserie.AbsoluteTotal.Value = 1;fckLRdataserie.PercentageTotal.Value = 1;fckLRfckLRrowseries.Add(dataserie);fckLRrowseries.Add(dataserie);fckLRfckLRarrRowseries = {rowseries,rowseries,rowseries,rowseries,rowseries,rowseries};fckLRfckLRFixedCrossTable table2x2 = new FixedCrossTable(&quot;Create by createFixedCrossDiagram &quot;, axisRowPrimary, axisRowSecond,&quot;Column title&quot;, axisColPrimary, axisColSecond, arrRowseries, empty);fckLR// genarate table:fckLRcreateFixedCrossDiagram(table2x2);fckLR</span>
+{{CGscriptConstructors_Template|Parameters=
-Result:
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
-<br />
+|Description=Create new 2x1 FixedCrossTable.}}
-<img _fck_mw_valid="false" _fck_mw_filename="Table2x2.png" alt="" class="fck_mw_notfound" />
+{{CGscriptConstructors_Template|Parameters=
-</p>
+{{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}}
+|Description=Create new 2x2 FixedCrossTable.}}
+|Methods=
+{{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}
+|Properties=
+{{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}
+{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}}
+}}
+=== Examples For Table 1x0 ===
+<source lang="javascript">
+DCS_use(12344983);
+// Get Axis:
+array axisNew = Axis_new("LuuTest");
+axisNew[AXIS_TEXT] = "Choose a D_Week";
+// Init:
+FixedCrossTableRowSeries rowseries;
+FixedCrossTableDataSeries dataserie;
+FixedCrossTableDataItem dataItemAbs;
+FixedCrossTableDataItem dataItemPct;
+// Set up a table
+// table 1x0
+rowseries = new FixedCrossTableRowSeries();
+dataserie = new FixedCrossTableDataSeries();
+number count;
+number countTotal = count() where D_Week != empty;
+for(number i = 201301; i < 201305; i++)
+{
+ Axis_addOption(axisNew, AxisOption_new("Week " + i.ToString(), ""));
+ count = count() where D_Week == i;
+ dataItemAbs = new FixedCrossTableDataItem();
+ dataItemAbs.Value = count;
+ dataItemPct = new FixedCrossTableDataItem();
+ dataItemPct.Value = count*100/countTotal;
+ dataserie.Add(dataItemAbs,dataItemPct);
+}
+// other
+Axis_addOption(axisNew, AxisOption_new("Week Other", ""));
+count = count() where D_Week != [201301-201304] && D_Week != empty;
+dataItemAbs = new FixedCrossTableDataItem();
+dataItemAbs.Value = count;
+dataItemPct = new FixedCrossTableDataItem();
+dataItemPct.Value = count*100/countTotal;
+dataserie.Add(dataItemAbs,dataItemPct);
+dataserie.AbsoluteTotal.Value = countTotal;
+dataserie.PercentageTotal.Value = countTotal*100/countTotal;
+rowseries.Add(dataserie);
+FixedCrossTable table1x0 = new FixedCrossTable("Create by createFixedCrossDiagram - D_Week", axisNew , rowseries, empty);
+// genarate table:
+createFixedCrossDiagram(table1x0);
+</source> Result:<br/>[[File:Table1x0.png]]
+=== Examples For Table 2x1 ===
+<source lang="javascript">
+DCS_use(15517112);
+// Get Axis:
+array axisRowPrimary = Axis_new("LuuTest1");
+axisRowPrimary[AXIS_TEXT] = "Gender test";
+Axis_addOption(axisRowPrimary, AxisOption_new("Mand", ""));
+Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", ""));
+array axisRowSecond = Axis_new("LuuTest2");
+axisRowSecond[AXIS_TEXT] = "Region test";
+Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", ""));
+Axis_addOption(axisRowSecond, AxisOption_new("Other Region", ""));
+array axisColPrimary = Axis_new("LuuTest3");
+axisColPrimary[AXIS_TEXT] = "Week test";
+Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", ""));
+Axis_addOption(axisColPrimary, AxisOption_new("Year Other", ""));
+array arrRowseries ={};
+number count;
+FixedCrossTableRowSeries rowseries;
+FixedCrossTableDataItem dataItemAbs;
+FixedCrossTableDataSeries dataserie;
+dataserie = new FixedCrossTableDataSeries();
+dataItemAbs = new FixedCrossTableDataItem();
+dataItemAbs.Value = 1;
+dataserie.Add(dataItemAbs,dataItemAbs);
+dataserie.Add(dataItemAbs,dataItemAbs);
+dataserie.AbsoluteTotal.Value = 1;
+dataserie.PercentageTotal.Value = 1;
+rowseries.Add(dataserie);
+rowseries.Add(dataserie);
+arrRowseries = {rowseries,rowseries,rowseries};
+FixedCrossTable table2x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, arrRowseries, empty);
+// genarate table:
+createFixedCrossDiagram(table2x1);
+createCrossDiagram({"Gender","Region"},{"D_Week"});
+</source> Result:<br/>[[File:Table2x1.png]]
+=== Examples For Table 2x2 ===
+<source lang="javascript">
+DCS_use(15517112);
+// Get Axis:
+array axisRowPrimary = Axis_new("LuuTest1");
+axisRowPrimary[AXIS_TEXT] = "Gender test";
+Axis_addOption(axisRowPrimary, AxisOption_new("Mand", ""));
+Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", ""));
+array axisRowSecond = Axis_new("LuuTest2");
+axisRowSecond[AXIS_TEXT] = "Region test";
+Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", ""));
+Axis_addOption(axisRowSecond, AxisOption_new("Other Region", ""));
+array axisColPrimary = Axis_new("LuuTest3");
+axisColPrimary[AXIS_TEXT] = "Week test";
+Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", ""));
+Axis_addOption(axisColPrimary, AxisOption_new("Year Other", ""));
+array axisColSecond = Axis_new("LuuTest4");
+axisColSecond[AXIS_TEXT] = "Age Group test";
+Axis_addOption(axisColSecond, AxisOption_new("Year 2014", ""));
+Axis_addOption(axisColSecond, AxisOption_new("Year Other", ""));
+array arrRowseries ={};
+number count;
+FixedCrossTableRowSeries rowseries;
+FixedCrossTableDataItem dataItemAbs;
+FixedCrossTableDataSeries dataserie;
+dataserie = new FixedCrossTableDataSeries();
+dataItemAbs = new FixedCrossTableDataItem();
+dataItemAbs.Value = 1;
+dataserie.Add(dataItemAbs,dataItemAbs);
+dataserie.Add(dataItemAbs,dataItemAbs);
+dataserie.AbsoluteTotal.Value = 1;
+dataserie.PercentageTotal.Value = 1;
+rowseries.Add(dataserie);
+rowseries.Add(dataserie);
+arrRowseries = {rowseries,rowseries,rowseries,rowseries,rowseries,rowseries};
+FixedCrossTable table2x2 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, axisColSecond, arrRowseries, empty);
+// genarate table:
+createFixedCrossDiagram(table2x2);
+</source> Result:<br/>[[File:Table2x2.png]]