4 Replies Latest reply: Jan 13, 2017 5:54 AM by Agrim Sharma RSS

    Simple question about missing values

    vyacheslav guzanov

      Hi,

      it should be very simple, but I still can't figure this out.

      Please help

       

      There are two tables

       

      Id
      1
      2

      3

       

        

      IdColor
      1green
      2blue
      3

       

      For Id 3 color is missing/not available. Not zero but rather null (nothing).

       

      Qliksense is absolutely correct, that color value for Id=3 is missing.

       

      The question is how to sort or find all values, for which Color is "missing"?

      There is no search or sorting for missing/null values.

      Thanks!

       

      Qlik-screenshot.png