Skip to main content
Question

Hi, I am trying to filter expression based on the results of a previous data query. Can this be done ?

  • December 7, 2022
  • 3 replies
  • 16 views

carol.swart
Level 2

I have a situation were depending on the result of the Query Data (17) I need to filter on either the Inbound Branch or Outbound or either for a particular branch, for the next data query. I keep getting a Syntax error, the documentation was not helpful.

Can this be done ?

 

image

3 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

The filter statement is not complete.

 

FILTER CASE

WHEN Selection= "Inbound' THEN

......

END = 'INBOUND'

 

But looking at your problem this wont work, create a field (Column Item in query data) instead with just the Case when statement, post that use the filter option in the path.... lets say you create a KPI called Selection, the path will have filters for the INBOUND or OUTBOND type...

 

uuid-9f3ba142-2fac-8fcf-80b6-458bbbca0365uuid-8aa8254e-dd12-165d-75d5-33a1ab88bf3d 

 

In the above image next 2 week is a path filter, you can check the following thread for something similar

https://www.celopeers.com/s/question/0D50700001vMFRvCAO/how-to-use-view-filters-in-action-flow-


carol.swart
Level 2
  • Author
  • Level 2
  • December 7, 2022

Thank you for your answer. The problem as I see it is that I need to filter on different fields, depending on the results or the the field Selection. The Inbound or Outbound is not an issue, it the field they need to match that changes either ZCDCI or ZCCID that is.


abhishek.chatu14
Level 11
Forum|alt.badge.img+4

Thank you for your answer. The problem as I see it is that I need to filter on different fields, depending on the results or the the field Selection. The Inbound or Outbound is not an issue, it the field they need to match that changes either ZCDCI or ZCCID that is.

That is where you can use the path filter right, using a router and path filter should help you ?