Dynamic Sort with 3 Sort Criteria (Static Data)
recently I wanted to implement a sort function on a table with static data. The following goals shall be achieved:
- Up to 3 criteria to be chosen of (any)
- The 2nd sort criteria shall not include the selection of the 1st (and the 3rd not of the 1st or 2nd)
- Sort sequence shall by either asc or dsc for all 3 cirteria (I used font awesome for displaying the icons)
- The amount of formulas shall be as minimal as possible
In the attached file (better because of the English/German function names) you can find a brief implementation.
During the implementaion I encountered the problem, that the sorting parameters asc / dsc cannot be "outsourced" in separated objects, because arcplan cannot interpret strings like "AUFSTEIGEND" (asc) as a valid parameter. But I found a workaround:
Write both parameters in separate single objects without "". Strangely, after hitting enter both objects show 95 resp. 96 as a value ... This way you can sort all criteria in the sequence you wish.
In order to change the way the sorting parameter is used, I opened a uservoice thread:
Sort Function with 0/1 Insated of ASC/DSC
Please support my suggestion if you find it helpful.
- 1,131 views
- 1 version
- 2 replies
- 2 followers
- Posted By:
- Axel Langer
- October 19, 2015
About this forum
- 26,617 views
- 30 topics
- 3 followers
Your forum to share new discoveries, nifty solutions and helpful workarounds