4 Replies Latest reply: Nov 27, 2015 6:58 AM by Gabrielle Souza RSS

    how to show null value in KPI field

      Hi guys! I hope that you can help me with this.

       

      I'm new usign Qlik Sense Desktop and i'm making some visualizations. One, in specific, i need to show some fields that at my ODBC connect that are empty.

       

      I tried to use some formulas, and i'm a newer user in it too, and it showed wrong values.

       

      when i use the  Count(if(isnull([queue]),1,0)) formula it shows me wrong values that dont matches with my mysql data. When I use the

      isnull(trim([sla])) formula it shows me the -1 number.

       

       

      What I'm doing wrong?

       

       

      Thanks in advance.