Skip to Content
-1

Hana filter expression: All values if input is blank

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 19, 2017 at 02:40 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded