2 Replies Latest reply: Dec 19, 2012 11:36 AM by dabaipang RSS

    Help! How to make sort on an expression in extension

      I have this Defintion.xml

      <ExtensionObject xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="SelectionMapCAFireBug" Description="SelectionMapCAFireBug" PageHeight="20">

                <Dimension DropTarget="1st Dimension" Initial="=PrescriberId"/>

                <Measurement DropTarget="Measure" Initial="" />

                <Measurement DropTarget="Measure" Initial="" />

                <Measurement DropTarget="Measure" Initial="" />

                <Measurement DropTarget="Measure" Initial="" />

                <Initiate Name="Chart.Title" value="Map"/>

                <Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/>

                <Initiate Name="Chart.Expression.1.0.Definition" value="=Latitude"/>

                <Initiate Name="Chart.Expression.2.0.Definition" value="=Longitude"/>

                <Initiate Name="Chart.Expression.3.0.Definition" value="=ZipCode"/>

                <!-- !IMPORTANT: Set the initial size of the QV map-->

                <Initiate Name="Layout.Normal.Width" Value="500" />

      </ExtensionObject>

       

      I need to sort <Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/> in descending order.

      I saw this post (http://community.qlik.com/message/241769) but I need to sort based on expression.

       

      Please help!

       

      Thank you very much.