3 Replies Latest reply: Apr 10, 2012 9:48 AM by Stefan Wühl RSS

    Null Function.

      Hi their.

       

      I'm trying to get Rid of the "MISSING NAME" Bar in my BAR CHART using the NULL function, but it's just not working.

       

      =if(FullName = 'MISSING NAME!', null(),

      if(FullName = '11', null(),

      if(FullName = '.', null(),

      if(FullName = ' ', Null(), FullName))))

        • Null Function.
          Stefan Wühl

          Do you use above as calculated dimension? Have you checked 'suppress when value is NULL' then?

           

          This should be equivalent:

          =if(FullName <> 'MISSING NAME!' and FullName <> '11' and FullName <> '.' and FullName = ' ',FullName)

           

          or

          =if(not match(FullName,'MISSING NAME!','11','.',' '),FullName)

           

          Or what do you use as dimension and expression?

           

          Instead of using a calculated dimension, you could probably use a set expression to filter your values, e.g. when using something like sum(Value):

           

          =sum({<FullName -= {'Missing Name!','11','.',' '}>} Value)

            • Null Function.

              Sorry Swuehl

               

              its just for the field of MISSING NAME, not the rest.

               

              =if(FullName = 'MISSING NAME!', null(),

               

              Apologize for that.

                • Null Function.
                  Stefan Wühl

                  Ok, so your expression (where? in a calculated dimension?) looks like:

                   

                  =if(FullName = 'MISSING NAME!', null(),FullName)

                   

                  I see no real problem at the moment, but maybe I am not getting your set-up properly. When you are saying, 'it's just not working', what do you mean, do you still get 'Missing Name' as dimension value? Could you please post a screenshot and your dimensions / expressions / dimension, expression and presentation chart properties or best a small sample app?