11 Replies Latest reply: Dec 6, 2016 5:01 AM by Sunny Talwar RSS

    Set Analysis - And and Or conditions

    Mohamed Ilyas Pitchai Mohamed

      Dear Members

       

      I'm very new to Qliksense and using Qliksense 3.0 desktop version to incorporate below SQL condition.

       

      "SELECT COUNT(1) FROM EMP_MASTR WHERE DATE_OF_JOING <= '31-JUL-2015'

      AND (QUIT_DATE IS NULL OR QUIT_DATE >= '31-JUL-2015')"

       

      Below is the snippet of my set analysis condition. But it's not returning the right values. Its returning  as "-"

      Importantly, I have a feeling that I'm not getting the QUIT_DATE records that are NULL.

       

      Your help is very much appreciated.

       

      Regards

      Ilyas