5 Replies Latest reply: Apr 6, 2018 10:22 AM by Sasidhar Parupudi RSS

    pivot table null values

    onur yilmaz

      Hello everyone,

       

      I have a standart qlik sense pivot table. In pivot table some of the values are dash(-).

       

      The requirement is to see space or zero (0) values instead of dash(-) values.

       

      I have already uncheck the "include null values", but stil have the dash values.

       

      I have tried below options but none of them not worked.

       

      if(Sum(CONS_QUANTITY)=null(),' ',Sum(CONS_QUANTITY))

      IF(ISNULL(Sum(CONS_QUANTITY)),' ',Sum(CONS_QUANTITY))

      If(Trim(CONS_QUANTITY) = '', null(), Sum(CONS_QUANTITY))


      for the script side, I have also tried below code but also not worked.


      NullAsValue 'CONS_QUANTITY';

      set NullValue=' ';

      pivot null.png

       

      Please suggest any appropriate solution,

       

      Any help will/would be appreciated.

       

      Thanks in advance.

       

      OY