Crossing point in a Graph

Wed, 21 Sep 2011 09:39:04 GMT

Hi I have a graph with two dimensions YearmMonth and CustomerSupplier, I also have an expressión with the folllowing formula:

Sum( {<[DocumentDate]={'<=$(=Date(vFFF)) >=$(=Date(vFIF))'} , CustomerSupplier={'Customer'} >} [InvoiceRemainingAmount]) + 
Sum( {<[DocumentDate]={'<=$(=Date(vFFF)) >=$(=Date(vFIF))'} , CustomerSupplier={'Supplier'} >} [InvoiceRemainingAmount]) *-1

The graph displays like this:

What I would like to know is the first date where the Customer Amount is larger than the Supplier's. I doný know if this is possible. Does anybody have an idea? Thanks in advance for you help and feedback.

topic Crossing point in a Graph in QlikView

Crossing point in a Graph