Skip to Content
-1

Hana filter expression: All values if input is blank

Jul 10, 2017 at 01:51 PM

1.1k

avatar image

Hello experts

We use a an input iarameter in a calculation view. If the input parameter is blank all values should be selected. I thought it should be easy. This is the implemented filter expression:

if('$$P_Input$$' = '',

match( "Char",'*'),

match( "Char",'$$P_Input$$'))

No syntax error is shown in the expression wizzard. But the data preview does not work. Following error message is shown by executing the data preview:

Error executing the query

Error: SAB DBTech JDBC: [2048]: column store error: search table error: [34051] not supported function: "if(" = ", match\"Char\", '*'), match("\Char\", ''))[here]

Can you tell me what is wrong with the code? Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Daniel Simon Jul 19, 2017 at 02:40 PM
0

Hello again,

I have found the solution. Following coding works:

match( "Char",

if('$$P_Input$$' = '',

'*',

'$$P_Input$$')

So the if statement has to be in the match statement. Not the other way around.

Match(IF(), THEN, ELSE)

Not:

IF()THEN(Match), ELSE (Match) )

I hope this helps someone. I am still looking for an CE tutorial.

Share
10 |10000 characters needed characters left characters exceeded