topic Sorting by Multiple Lease Events in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-Multiple-Lease-Events/m-p/456341#M1159502 <HTML><HEAD></HEAD><BODY><P>Hi, I'm looking to sort data on this chart by lease break date.&nbsp; Each building has up to 5 lease breaks so I'm thinking I need some sort of IF statement to get the sort to look at the earliest date from today but across all the buildings.</P><P></P><P>The Dimension is "Location"</P><P></P><P>The Expressions are Lease Break 1 - 5 and Lease Expiration (blue dots below)</P><P></P><P><IMG __jive_id="25449" class="jive-image-thumbnail jive-image" onclick="" alt="Sort by Dates.png" src="/legacyfs/online/25449_Sort by Dates.png" width="450" /></P><P></P><P>As always ideas and help appreciated.</P><P></P><P>Thanks</P><P>Rob</P></BODY></HTML> Wed, 21 Nov 2012 17:41:32 GMT 2012-11-21T17:41:32Z Sorting by Multiple Lease Events https://community.qlik.com/t5/QlikView/Sorting-by-Multiple-Lease-Events/m-p/456341#M1159502 <HTML><HEAD></HEAD><BODY><P>Hi, I'm looking to sort data on this chart by lease break date.&nbsp; Each building has up to 5 lease breaks so I'm thinking I need some sort of IF statement to get the sort to look at the earliest date from today but across all the buildings.</P><P></P><P>The Dimension is "Location"</P><P></P><P>The Expressions are Lease Break 1 - 5 and Lease Expiration (blue dots below)</P><P></P><P><IMG __jive_id="25449" class="jive-image-thumbnail jive-image" onclick="" alt="Sort by Dates.png" src="/legacyfs/online/25449_Sort by Dates.png" width="450" /></P><P></P><P>As always ideas and help appreciated.</P><P></P><P>Thanks</P><P>Rob</P></BODY></HTML> Wed, 21 Nov 2012 17:41:32 GMT https://community.qlik.com/t5/QlikView/Sorting-by-Multiple-Lease-Events/m-p/456341#M1159502 2012-11-21T17:41:32Z