9 Replies Latest reply: Jul 3, 2013 4:57 AM by Nicolas MARTIN RSS

    How to display a string instead of '-' (null) in Ajax?

    Nicolas MARTIN

      Hello,

       

      I have the following data:

       

       

      section access;
        
      Access:
      LOAD * INLINE [
      ACCESS, USERID, COUNTRY
      ADMIN, ADMIN, *
      USER, USER_USA, USA
      USER, USER_FRANCE, FRANCE
      ];
        
      section Application;
            
      Sells:
      LOAD * INLINE [
      COUNTRY, Vendor, Value
      USA, John, 10
      FRANCE, Marcel, 20
      ];
        
      CONCATENATE (Sells)
      LOAD * INLINE [
      COUNTRY, Value
      USA, 50
      ];
      

       

       

       

      In my application, I want to make a chart with the sum of sells by vendor. But when there is no vendor, I'd like to have the string "OTHER VENDOR" instead of "-" (null).

       

      I made a custom dimension:

      =if(isnull(Vendor), 'OTHER VENDOR', Vendor)
      

       

       

      It works fine in QlikView Desktop:

      2013-07-02_172720.png

       

       

      fine in QlikView Desktop with web view

       

      2013-07-02_172829.png

       

      but when I use a web browser with Ajax, it doesn't work:

      2013-07-02_173121.png

       

       

       

      If I turn off the section access, it works.

       

       

      Have I another way of using a string instead of the "-" when null?

       

      I'm using QV server v11 SR 2.