How to apply filter using Parameter attribute for Exclude checkbox ?

Question

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.

Karthick_ · Answer

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,

};

Mostafa Morsy-Oracle · Answer

@Karthick_

you may use expression Filter to exclude parameter value

Ex:

Joel Acha · Answer

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.

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.