Difference between revisions of "Tabulation setSortVerticalWhichColumn"
Nguyenduyan (talk | contribs) (Created page with "Category:Sorting_functions {{HelpFiles}} = Tabulation_setSortVerticalWhichColumn = Define which column should be sort == Syntax == Tabulation_setSortVerticalWhichColu...") |
|||
(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 09:44, 4 March 2020
Contents
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