topic Re: Sort by Expression in QlikView

Sort by Expression

Tue, 07 Jun 2011 12:07:35 GMT

Hi All,

How do I associate Sort Orders => Sort by Expression to a particular field in a group using a macro.

Thanks in advance

Re: Sort by Expression

Tue, 07 Jun 2011 16:01:25 GMT

set fld=ActiveDocument.GetField("Salesman")
set fldsrt = fld.GetDefaultSortCriteria 
fldsrt.SortByExpression = 1
fldsrt.Expression.v = "sum(Amount)"
fld.SetDefaultSortCriteria fldsrt

Re: Sort by Expression

Wed, 08 Jun 2011 07:03:54 GMT

Hi Miller,

Thanks for your reply. I found a way to achive this.

groups = ActiveDocument.GetGroups

set gp = groups(0).GetProperties

set sc = gp.SortCriterias

sc(0).SortByExpression = 1

sc(0).Expression.v = "sum(Amount)"

groups(0).SetProperties gp