Skip to Content

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

Conditional Data passing to chart, how to make Dim value zero

Hello,

I have a req where I need to select a value in Time dimension (With Dimension_filter type) . I need to show say April to December in the chart on Horizontal axis.

If I select April May June in time dim..I need to show only values for April May June with values and all other things without values.

The below code, If I pass all time dim values in setDataSelection , it shows by default with values.

sample code: This only shows all values in the setDataSelection, here for that condition if I do not pass 1415.JUN , the chart will not show June on the axis at all. But I need to show June in the axis but without any value to it. Is it poissible ?

STR = FILTER.getFilterExt("/CPMB/NDD9Q3V");

if (STR == "1415.APR; 1415.MAY")

{CHART_14.setDataSelection( {"/CPMB/NDD9Q3V": ["1415.APR", "1415.MAY","1415.SEP", "1415.OCT", "1415.NOV","1415.DEC"] } ); }

else if ((STR == "1415.APR; 1415.MAY; 1415.JUN") || (STR == "+1415.Q1(/CPMB/NDD9Q3V)"))

{CHART_14.setDataSelection( {"/CPMB/NDD9Q3V": ["1415.APR", "1415.MAY","1415.JUN","1415.JUL","1415.AUG","1415.SEP", "1415.OCT", "1415.NOV","1415.DEC"] } ); }

else if (STR == "1415.APR; 1415.MAY; 1415.JUN; 1415.JUL")

{CHART_14.setDataSelection( {"/CPMB/NDD9Q3V": ["1415.APR", "1415.MAY", "1415.JUN", "1415.JUL","1415.SEP", "1415.OCT", "1415.NOV","1415.DEC"] } ); }

else if (STR == "1415.APR; 1415.MAY; 1415.JUN; 1415.JUL; 1415.AUG")

{CHART_14.setDataSelection( {"/CPMB/NDD9Q3V": ["1415.APR", "1415.MAY", "1415.JUN", "1415.JUL","1415.AUG","1415.SEP", "1415.OCT", "1415.NOV","1415.DEC"] } ); }

hope I was clear in what I was asking for. Please help.

Hello Guys, please throw some light on how to get this working, any workarounds etc. are much appreciated.

Kind Regards,

krishna

Former Member
Not what you were looking for? View more on this topic or Ask a question