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

    Using Not In Condition in Qlik

    Supriya R

      Hi,

       

      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

       

      count({

      <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