Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Edit Crosstab NULL Values

    Posted Wed March 25, 2020 10:39 AM
    Hello everyone,

    I'm new to Cognos Analytics. I'm trying to build a CrossTab. The viz gives me (no value) for all NULL values. I would like to edit this to either make it '0' or Blank. Could you please help me on this?

    Additionally, I tried the following methods but it didn't work out.

    -> CASE
       WHEN Quantity = '' THEN '0'
        ELSE Quantity END
    -> coalesce (trim ( both, Quantity),'0')

    Let me know your thoughts.


    ------------------------------
    Sri
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Edit Crosstab NULL Values

    Posted Thu March 26, 2020 11:37 AM
    Hello,

    You can try the following,

    Try the "clean" functionality as mentioned at this link: https://www.ibm.com/mysupport/s/question/0D55000005cRQPkCAO/no-value-and-not-0-in-dashboard-with-crosstab?language=en_US

    The video mentioned at that link is actually located here: https://www.youtube.com/watch?v=plosFS5cxHQ



    ------------------------------
    Steve Templeton
    ------------------------------

    Original Message


  • 3.  RE: Edit Crosstab NULL Values

    Posted Fri March 27, 2020 02:21 AM
    Edited by System Admin Fri January 20, 2023 04:18 PM
    Hello Sukasri,

    have you tried with the format option for the Crosstab cells?
    You can try putting a zero here.

    ------------------------------
    Alex Santamarta
    ------------------------------

    Original Message


Related Content