Exists/Contains/Match in Qlikview

[#1]

For one person_key there are multiple QST_ID's and ANS_ID's.

In Progress Outcomes chart i am checking the following condition for Quit Y/N?

IF for that person_key  we have QST_ID=1472 and ANS_ID=6429 it should show 'Y'.

But because of mutiple QST_ID's for a person_key i am not getting desired output.Any Help?

[swuehl]

Maybe like this (assuming you've selected one PERSON_KEY):

if( count({<QST_ID = {1472}, ANS_ID ={6429} >} PERSON_KEY) > 0,'Y','N')

[#3]

No it din help.

In sql server we have IN anything similar to that in Qlikview?

tried Match still didnt work

[tresB]

Try something like:

If (

         FindOneOf(Concat(Distinct QST_ID,'/'), '1472') And FindOneOf(Concat(Distinct ANS_ID,'/'), '6429')

, 'Y', 'N'

)

Or,

if( count({<QST_ID = {1472}> *<ANS_ID ={6429} >} PERSON_KEY) > 0,'Y','N')  // just tweaking Stephans''stuff a bit.

[swuehl]

Are your tables properly linked? Could you upload a small sample that demonstrates this issue?

[#6]

tried both still not working

[#7]

hey Treseco,

Thanks a lot !!

Second condition worked !!