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

    how to display the frequence of the null values

      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 .