2 Replies Latest reply: Oct 29, 2014 3:38 PM by Anand Chouhan RSS

    IsNull, Select, Remove Null Values

      Hi everyone,

       

      Someone can help me please?


      How can I do, if we have "IsNull" + select?

       

      Here is my request :


      ISNULL((SELECT TA.TBL_LIB FROM TABLES TA WHERE TA.TBL_ID = 'FA4' AND TA.TBL_CODE = A.FA4_CODE), '') AS 'C4 Article',

       

      How i can handle the NULL values and remove them on Qlikview?

      what's the NULL handling in the Qlikview?

      how can i use IsNull Individually to the fields and then use your expression?

       

      I would like to convert this Sql request in into Qlikview

       

       

      Thank you to all.

       

      Regards