simple sorting macro for chart not working

Fri, 05 Apr 2013 19:50:46 GMT

Based on some other posts here, I'm trying a simple macro, to sort my chart (a straight table).

SUB testSort
set fld = ActiveDocument.GetField("Affiliate")
set fldsrt = fld.GetDefaultSortCriteria
fldsrt.SortByAscii = 0
fldsrt.SortByFrequency = 0
fldsrt.SortByLoadOrder = 0
fldsrt.SortByNumeric = 0
fldsrt.SortByState = 0
fldsrt.SortByExpression = 1
fldsrt.Expression.v = "[Renewable File Size]"
fld.SetDefaultSortCriteria fldsrt
END SUB

The intention is to sort rows according to the expression [Renewable File Size] but running this macro has no effect. No error message, but it does nothing.

What am I missing here, is there some additional step being left out?

Thanks in advance for your ideas.

Hanno Beck

Agora, Inc.

topic simple sorting macro for chart not working in QlikView

simple sorting macro for chart not working