Custom Set Items in Drop Down Filter

[Former Member]

Hello,

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.

Thanks

[Former Member · Accepted solution]

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) {

  if(DROPDOWN_1.getSelectedText()==element.text)

  { message = "";}

  else { message = "No Data Available";}

});

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

Regards

Marish

[Former Member · Accepted solution]

Hey Marish,

Thanks for your answer.

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

Thanks,

Alex