Script to Control Measure in SAP Analytics Cloud Table Using Range Slide

[RajuRam]

Hello,

I am working on an analytic application in SAP Analytics Cloud (SAC) using SAP BW live data. I want to control a measure in a table using a range slider with scripting. Specifically, I need to filter the measure dynamically based on the range slider's values. I have a range slider component (RangeSlider_1) and a table component (Table_1) that displays SAP BW data. Is it possible to accomplish this with scripting?

Thank you.

[jain06]

Hi,

We can configure Range slider with the setting enabled "Enable the writeback in runtime" and write the values to 2 different Script variables.

Create a calculated measure with the if condition =if(Measure1 < Scriptvariable_1 and Measure >Scriptvariable_2, Measure1,0) and enable Zero suppression in the table.

I have assumed that the table contains only 1 measure.

Thanks,

Jain

[RajuRam]

Dear Mr.Jain,

Thank you for your response. I am revising my response as I tried again and got almost everything to work. However, my table has many measures, so I couldn't do zero suppression. I need your help to fix this.

Regards,

R Raju