5 Replies Latest reply: Dec 13, 2017 9:59 AM by Devarasu R RSS

    Expression to display non null and zero values

    ra ta

      Hi, I am trying to display a table and i would like not to rows with null or zero values.

       

      Can you please suggest a measure expression for that please ?

       

      Thanks very much.

        • Re: Expression to display non null and zero values
          Devarasu R

          Hi,

           

          yes it can be done in many ways.

          method 1:

          suppress null value in your chart dimension

          method 2:

          cal.dimension

          if( len(trim(Account))>0, Account) // make sure suppress null.

          Method 3:

          using set analysis

          sum( {<Account={"=len(trim(Account))>0"}>} Sales)

          method 4:

          using back end script method, try to make non distinct value (master dimension should contain all the possible value and not null) and exclude 0 u can use where clause

          Fact:

          load * from table.qvd (qvd) where  Sales <>0;

           

          refer to the sample,

          Capture.JPG

          Thanks,

          Deva