6 Replies Latest reply: Jun 5, 2018 11:43 AM by Richard Bartley RSS

    Cannot hide marker when second measure is null/zero

    Richard Bartley

      Hi everyone,


      I have a combo chart where the value of one measure is null for some years, while the other measure is not null (see 2012 and 2013 below)


      Organic Null 2nd Measure.PNG


      I have attempted to exclude the nulls from the chart, but this is not working.  The definition is:


      if(getSelectedCount([Member State Name])=0,Num(Sum({<CHART_SUB_ID={'2_2'},[Member State Name]= {'European Union'}, TIME_PERIOD={">=2012"},[Data Null Flag]={'0'},[Data Zero Flag]={'0'}>}DATA),'# ##0'),Num(Sum({<CHART_SUB_ID={'2_2'},[Member State Name]= {$(=vMSValue)}, TIME_PERIOD={">=2012"},[Data Null Flag]={'0'},[Data Zero Flag]={'0'}>}DATA),'# ##0'))


      From displaying this data in a table (see below), I can see that for 2012 and 2013 we have NULL values.



      Organic Null 2nd Measure Table.PNG



      And if I remove the first measure, the null records are hidden:



      Organic Null 2nd Measure 1 measure.PNG


      So, it seems to me that the instruction in the set analysis is simply being ignored when two measures are used in a combo chart. I have also tried simply adding if([Data Zero Flag]='0'...., but this does not work either.


      Does anyone have any workaround for this?