Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
0 Replies