Skip to Content
0

Not Working... Multiple IN Clause for Filter Expression

Jan 17 at 04:11 AM

117

avatar image

In my Calc View, I have an Projection Expression Filter with 2 Input Parameters that are configured for Multiple Values. When I execute the Calc View no results get returned. When I remove one of the "IN" Clauses I get results.

It seems like you cannot have more than 1 IN Clause in an Expression Filter!
Can someone try this and let me know if you are able to use more than 1 In Clause in their "Expression Filter"?

in("0CALMONTH", $IP_BPER$)  and 
in("GCONSGRP",  $IP_GCONSGRP$)

We are on HANA 1.0 SPS12

SQL
10 |10000 characters needed characters left characters exceeded

Did you check there are rows validating the two conditions?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Kenneth Murray Jan 17 at 03:34 PM
0

Hi All, Thanks for the views. I was finally able to get it to work.

(in("0CALMONTH", $$IP_BPER$$) or in("0CALMONTH", $$IP_APER$$))  and in("GCONSGRP",$$IP_GCONSGRP$$)

It seems like I tried the same format many times and it failed, but finally, it seemed to work.

Thanks for any feedback!

Share
10 |10000 characters needed characters left characters exceeded