4 Replies Latest reply: Nov 30, 2016 9:30 AM by Nirmal V RSS

    Null Value Issue

    Nirmal V

      Hi All,

       

      I have below two tables brought in Qlik Sense. Then,  I am trying to put all three columns in a simple table Chart.  .

       

      Employee IDName
      1ABC
      2CD
      3EF
      4GH
      5IJ
      6KL
      7

      MN

       

       

       

      Employee IDSalary
      1100
      2200
      3300
      4400

       

       

      Qlik Sense Table :

       

        

      Employee IDNameSalary
      1ABC100
      2CD200
      3EF300
      4GH400
      5IJ
      6KL
      7MN

       

      If the salary is null in the above table chart, i want to display as "NULL". I tried to put the expression If(IsNull(Salary),'NULL',Salary).

      But this expression is not working and not giving me the expected result.

       

      Can you please help me to fix this issue?

       

      Thanks

      NV.