Change sort-priority in straight table with macro

warfollowmy_ver — Sat, 16 Nov 2024 04:59:03 GMT

I understood how to change the sorting order in expressions and dimensions of a direct table, but this doesn’t do anything for my task until I can control the sorting priority.

How can I use the macro to change the sort priority order in a straight table?

set chart=ActiveDocument.GetSheetObject("CH11")

set Prop = chart.GetProperties

Prop.Dimensions.Item(0).SortCriteria.SortByNumeric = 1
Prop.Expressions.Item(0).Item(0).Data.ExpressionData.SortCriteria.SortByNumeric = 1

chart.SetProperties Prop

Re: Change sort-priority in straight table with macro

warfollowmy_ver — Wed, 12 Dec 2018 11:50:30 GMT

set chart=ActiveDocument.GetSheetObject("CH11")

chart.SortBy 10

set Prop = chart.GetProperties

Prop.Dimensions.Item(0).SortCriteria.SortByNumeric = 1
Prop.Expressions.Item(0).Item(0).Data.ExpressionData.SortCriteria.SortByNumeric = 1

chart.SetProperties Prop

topic Re: Change sort-priority in straight table with macro in QlikView

Change sort-priority in straight table with macro

Re: Change sort-priority in straight table with macro