Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Apply a like filter

Received Response
12
Views
3
Comments

Dear all, is it possible to apply two like filters with AND logic clause in an analytics project ?


Many thanks in advance

Answers

  • Yes, you can.

    As you don't provide any hint on the product and version, it's impossible to be more precise.

  • User_R6LB9
    User_R6LB9 Rank 1 - Community Starter

    I 'm designing a Dashboard consisting of

    • a table with sevaral textual columns
    • a prompt with a listbox of strings to filter the table on a specific column

    Let's consider the table column named "A". I wuold have all the rows conteining all the strings selected in the prompt (this is the AND case).

    Secondly if trying a way to define at runtime the logic operators (AND , OR, NOT, ...) to be used in the filter conditions.


    Many thanks

  • User_R6LB9
    User_R6LB9 Rank 1 - Community Starter

    Any suggestions?