Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Crossing point in a Graph

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:

Captura.JPG

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.

Labels (1)
0 Replies