4 Replies Latest reply: Jun 17, 2015 5:21 AM by ferhat oumohand RSS

    how to display the frequence of the null values

    ferhat oumohand

      hello All,

       

      I have to display  in the graphe the frequence of the  NULL values for a field .But QlikView not allow this.

      the Idea is when i load the field , i will transforme the NULL value into an other value like '<NULL>'


      exemple : the field is "status"

      in the instruction load i will do :


      If ( IsNull(status), '<NULL>', status) .  But it's not working. I know that i am not far of the solution

       

      Can someone help me ?

       

      Thanks in advances .

       

      Regards,

      Ferhat