Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Custom Set Items in Drop Down Filter

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

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question