Using Not In Condition in Qlik

[berryandcherry6]

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

[Muthu]

Hi Supriya,

Please go through the below thread for not equal to in Qlikview, I think if you follow the below steps you will get right answer.

Set Analysis - "Does not equal"

Regards,

Muthu

[berryandcherry6]

Hello Muthu,

I referred that link, it is applying not in only for one condition, i my query it has three condition and i need to remove all three condition lender offer id.

How could i do this?

Please help me on this

[Muthu]

Please send a sample qvw.

[berryandcherry6]

I have attached in query, please check