3 Replies Latest reply: Jun 3, 2011 11:17 AM by Eduardo Correa da Silva RSS

    Script to rename Nulls as 'Errors'

      Hi Guys

       

      I have loaded a few excel sheets into qlikview, some of the columns have no data for particular customers ( after reading other posts etc I know that nulls() are mad complicated!!)

       

      Just wondering is there a simple way to "rename" and blank field in ths script. Basically I wish to build a table where I can search by the Nulls so I know what data fields have gaps

       

      I have tried the following to no avail perhaps someone can heeeellllppp

       

       

      Thanks

       

      A

      if([REPAYMENT FREQUENCY]= '','Error',[REPAYMENT FREQUENCY]) as [REPAYMENT FREQUENCY]

       

      if([REPAYMENT FREQUENCY]= null(),'Error',[REPAYMENT FREQUENCY]) as [REPAYMENT FREQUENCY]