Oracle Analytics Cloud and Server

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

How to apply filter using Parameter attribute for Exclude checkbox ?

Received Response
41
Views
3
Comments

Hi

I have embedded the OAC Workbook within my website.

I need to apply filter via my code by using parameter attribute for "Exclude" checkbox available in the List Filter.

I can able to apply List Filter values, Even Top Botton N. But not able to apply the same using "Exclude" though I've created a parameter for the same.

image.png
Tagged:

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    if I understand correctly, your code populates the parameter. If so you need to check the Exclude option of your filter and then also add your parameter to the filter section of your visualisations.

    image.png

    In the example above, I can set the value of the Exclude Year parameter and once it's added to the filter section of the visualisation, the value of the parameter is excluded.

    image.png
  • Mostafa Morsy-Oracle
    Mostafa Morsy-Oracle Rank 6 - Analytics Lead

    @Karthick_

    you may use expression Filter to exclude parameter value

    Ex:

    Screenshot 2024-09-18 at 2.24.57 PM.png
  • Karthick_
    Karthick_ Rank 3 - Community Apprentice

    Thanks for the reply. What I need is the format same like below code,

    I need to apply filters after embedding by the Javascript code

    Eg: Add Technology & Furniture to Category(Dashboard Filter) and I need to check the checkbox "Exclude".

    var parameters={
    "p1n": "Pararm_Category",
    "p1v": ["Technology","Furniture"],
    "p2n": "Pram_IsExcludesVertical",
    "p2v": 1,
    };