16 Replies Latest reply: Oct 13, 2017 11:48 AM by Kris Markee RSS

    Aggr function and its sorting property

    Kris Markee

      Would someone be so kind as to provide a sample (maybe a qvw) that shows how the sorting feature of the Aggr function works.  The Online Help describes it but their data and qvw sample does not include the field that they use in the written example.  And when would one use this, just if using an ABOVE or BELOW function?  Thanks.

      https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/aggr.htm

      Aggr({SetExpression}[DISTINCT] [NODISTINCT ] expr, StructuredParameter{, StructuredParameter})

      StructuredParameter consists of a dimension and optionally, sorting criteria in the format: (Dimension(Sort-type, Ordering))