Latest revision as of 08:44, 4 March 2020

Tabulation_setSortVerticalWhichColumn

Define which column should be sort.

Use combine with

Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);

or

Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);

Syntax

Tabulation_setSortVerticalWhichColumn( column);

Arguments

column: is a number expression. It's the column you want to sort (start with 0)

Return type

empty

Example

// Example for vertical sort on 1x1
DCS_use(14913246);
Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
Tabulation_setSortVerticalWhichColumn(1);
createCrossDiagram({"D_Region_Detailed"},{"D_Gender"});

Before set sort

After set sort vertical high to low on second column

// Example for vertical sort on 1x2
DCS_use(14913246);
Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
Tabulation_setSortVerticalWhichColumn(1);
createCrossDiagram({"D_Region_Detailed"},{"D_Gender","D_Age"});

Before sort:

After sort the second column from low to high

// Example for vertical sort on 2x1
DCS_use(14913246);
Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
Tabulation_setSortVerticalWhichColumn(1);
createCrossDiagram({"D_Region_Detailed","D_Gender"},{"D_Age"});

Before sort

After sort the second column high to low

@@ Line 7: / Line 7: @@
 Use combine with
 Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
@@ Line 28: / Line 29: @@
 <source lang="javascript">
-DCS_use(15569074);
+// Example for vertical sort on 1x1
+DCS_use(14913246);
+Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
+Tabulation_setSortVerticalWhichColumn(1);
+createCrossDiagram({"D_Region_Detailed"},{"D_Gender"});
+</source>
+Before set sort
+[[File:2020-03-04 15-02-41.png]]
+After set sort vertical high to low on second column
+[[File:2020-03-04_15-14-12.png]]
+<source lang="javascript">
+// Example for vertical sort on 1x2
+DCS_use(14913246);
 Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
 Tabulation_setSortVerticalWhichColumn(1);
-createCrossDiagram({"Q2"}, {"Panel_Age"});
+createCrossDiagram({"D_Region_Detailed"},{"D_Gender","D_Age"});
+</source>
+Before sort:
+[[File:2020-03-04_14-47-55.png]]
+After sort the second column from low to high
+[[File:2020-03-04_14-46-28.png]]
+<source lang="javascript">
+// Example for vertical sort on 2x1
+DCS_use(14913246);
+Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
+Tabulation_setSortVerticalWhichColumn(1);
+createCrossDiagram({"D_Region_Detailed","D_Gender"},{"D_Age"});
 </source>
-Before set sort vertical low to high which column 1
+Before sort
-[[File:Vertical_sort_before.png]]
+[[File:2020-03-04_15-27-30.png]]
-After set sort vertical low to high which column 1
+After sort the second column high to low
-[[File:Vertical_sort.png]]
+[[File:2020-03-04_15-28-14.png]]