Skip to Content
avatar image
Former Member

Custom Set Items in Drop Down Filter


I have set up a drop down with manual inputs that can filter multiple data sources.

Some data sources will not have the item that is in the drop down so it would not be able to filter on the selected item.

When this type of selection occurs the data source does not acknowledge the attempted filter and acts if there is nothing to filter on.

I was expecting to see "No Data Available" if I try to filter on an item not available in the data source.

I can go around this issue by checking if the drop down item is available to filter on in the data source and show the chart in the proper state.

Is there a different way to approach this issue?

I am using HANA Views and DS 1.5.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2015 at 02:11 PM

    Hi Alex,

    The No Data Available smoke screen for Crosstab /Chart shows up only if the item filtered is available in the data source is without values. For your case checking the drop down values is the best way.

    You can use the code below for comparing the drop down values. The for-each function executes faster compared to other methods.You can add the action item instead of alert.

    var array = DS_1.getMembers("0REGION", 100);

    var message = "";

    array.forEach(function(element, index) {


      { message = "";}

      else { message = "No Data Available";}


    if(message!="") { APPLICATION.alert(message); }



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey Marish,

      Thanks for your answer.

      Do you know why the data source does not accept a filter value outside the filter values available?