Skip to Content

OR condition using FilterPanel object

Hi, I am using Filterpanel.submit() function in design studio application, for one of the selections, filter panel dimensions should result the data with OR condition,

for example, Dim1, Dim2 and Dim3 are in the filter pane, if the user gives the value for Dim1 and Dim3, the above function would work as AND operator, but the result set in the datasource should bring both filtered values separately not as combination. please let me know if it is possible or not?

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Jan 05, 2017 at 07:52 AM

    Hi Sreekanth,

    Dimension filters normally apply as an "AND" operation. I can't thing of a way to apply the OR operation using the Filter Panel or the setFilter() script function. You may need to do this via purpose-built prompt variables, although this is probably not an ideal approach.

    As an experiment you could try applying either of the first two settings in the data source Initial View for each of the dimensions but I think it's a long shot:



    or-filter.png (77.2 kB)
    Add comment
    10|10000 characters needed characters exceeded