Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hey,
I'll answer here as well so we can reference it later on.
You could add something like the line below to your definition.xml file:
<Initiate Name="Chart.Dimension.0.Sort.ByYValue.Use" value="1"/>
There is a qvprops.htm file that exposes all the different chart properties. I've searched and searched but it seems we have removed it from the SDK so I'll just upload it here instead with reservations that it might be outdated.