Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sorting by Multiple Lease Events

Hi, I'm looking to sort data on this chart by lease break date.  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.

The Dimension is "Location"

The Expressions are Lease Break 1 - 5 and Lease Expiration (blue dots below)

Sort by Dates.png

As always ideas and help appreciated.

Thanks

Rob

Tags (2)
Community Browser