topic Exists/Contains/Match in Qlikview in QlikView

Exists/Contains/Match in Qlikview

Wed, 16 Oct 2013 10:38:39 GMT

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 — Wed, 16 Oct 2013 10:41:58 GMT

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

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

Wed, 16 Oct 2013 10:47:33 GMT

No it din help.

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

tried Match still didnt work

tresB — Wed, 16 Oct 2013 10:49:34 GMT

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 — Wed, 16 Oct 2013 10:53:31 GMT

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

Wed, 16 Oct 2013 11:22:52 GMT

tried both still not working

Wed, 16 Oct 2013 11:25:26 GMT

hey Treseco,

Thanks a lot !!

Second condition worked !!