Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Using Not In Condition in Qlik

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

Tags (2)
4 Replies
administarator
Contributor II

Re: Using Not In Condition in Qlik

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
Contributor II

Re: Using Not In Condition in Qlik

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

administarator
Contributor II

Re: Using Not In Condition in Qlik

Please send a sample qvw.

berryandcherry6
Contributor II

Re: Using Not In Condition in Qlik

I have attached in query, please check