More actions
Nguyenduyan (talk | contribs) Created page with "Category:Sorting_functions {{HelpFiles}} = Tabulation_setSortVerticalWhichColumn = Define which column should be sort == Syntax == Tabulation_setSortVerticalWhichColu..." |
No edit summary |
||
(4 intermediate revisions by one other user not shown) | |||
Line 4: | Line 4: | ||
= Tabulation_setSortVerticalWhichColumn = | = Tabulation_setSortVerticalWhichColumn = | ||
Define which column should be sort | Define which column should be sort. | ||
Use combine with | |||
Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh); | |||
or | |||
Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow); | |||
== Syntax == | == Syntax == | ||
Line 20: | Line 29: | ||
<source lang="javascript"> | <source lang="javascript"> | ||
DCS_use( | // 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_setSortOrderVertical(Tabulation_SortOrder_LowToHigh); | ||
Tabulation_setSortVerticalWhichColumn(1); | Tabulation_setSortVerticalWhichColumn(1); | ||
createCrossDiagram({" | 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> | </source> | ||
Before | Before sort | ||
[[File:2020-03-04_15-27-30.png]] | |||
After | After sort the second column high to low | ||
[[File: | [[File:2020-03-04_15-28-14.png]] |
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