Skip to Content
avatar image
Former Member

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


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,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 29, 2014 at 09:59 AM

    Hello Anyone please help me if I can achieve the above functionality ?

    Add comment
    10|10000 characters needed characters exceeded