Toggle menu
875
3.8K
30.2K
279.1K
Catglobe Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Tabulation setSortVerticalWhichColumn: Difference between revisions

From Catglobe Wiki
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(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_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
Tabulation_setSortVerticalWhichColumn(1);
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>
</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]]

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