Some question about filtering out unwanted relationship

[dirkchin63]

Hi all, I could like to find out which pairs of stock price have correlation over 0.85 in last year.

I input the following in Neo4J:

MATCH (a)-[c:Correlation]-(b)
#Find out the relationship with correlation>0.85 & Exclude relationships with the stock itself (the correlation must be 1)
WHERE c.correlation > 0.85 and a<>b
Return *
The outcome:

I founded out there are 2 pairs with correlations higher than 0.85 (highlighted in yellow)
But some extra relationships (less than 0.85) are also included in the graph.
May I have some recommendations that how can I excluded those extra relationship when inputting order to Neo4J. Thanks!

[dominicvivek06 · Accepted solution]

can you uncheck connect result nodes under settings and test it.

Hello @dirkchin63, welcome to Neo4j community.

Please, match the exact relationship and relationship properties also.

Filter out relationships based on other relationships properties Cypher

We use WITH clause for the dynamic behavior and passing the result to the next query. If you specify in the relationship along with WITH clause, the relationship values are passed, and with that you can easily get the connected nodes. Even the -[]-> can be called for the relationship needed. All of this can be performed dynamically. I have done this many times for many complex queries.

[dirkchin63]

Done! I am a newcomer of Neo4J and Thank you very much for your help!