Where condition in set analysis

[srik00001]

Hello,

How do i write the below statement into a where condition in qlikview set analysis

Count({<Field1={'A'}, Customers where customer rank for Field1='B' <=10>} Distinct Product_ID)

Let me know if uploading a sample file would help in understanding the question better.

Appreciate your help.

Thanks

[ToniKautto]

Yes, a sample would make it easier to advise.

My guess in your question is that you need to use Set Operators and/or P() function to accomplish the intersection you are looking for. See QlikView help for details on set analysis options.

[srik00001]

I have tried using the intersection function but could not get it to work.

I have attached the sample files along with results (highlighted columns in excel).

Your help is very much appreciated.

Thanks,

Sri