4 Replies Latest reply: Apr 12, 2017 6:29 AM by Supriya R RSS

    Using Not In Condition in Qlik

    Supriya R



      i want to find  count of lender offer id's who are not involved in survey completed, certificate downloaded and click with logtype id = 23 from cousecompleted lender offer ids.


      Below is the code i have used



      <lender_offer_id -= {"=count({$< final_test_status={'Passed'},course_completed={'1'},certificate_download_count = {'>0'} >}distinct lender_offer_id)"}>


      <lender_offer_id -= {"=count({$<log_type_id={'23'} ,final_test_status={'Passed'},course_completed={'1'}>}distinct lender_offer_id)"}>


      <lender_offer_id -= {"=count({$<survey_completed={'1'},course_completed={'1'},final_test_status={'Passed'}>}distinct lender_offer_id)"}>


      distinct lender_offer_id)


      But above query gives wrong Number, Correct number should be 22.

      and see attached qvf file