Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

simple sorting macro for chart not working

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.

0 Replies