Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srik00001
New Contributor II

Where condition in set analysis

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

2 Replies
Employee
Employee

Re: Where condition in set analysis

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

Re: Where condition in set analysis

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

Community Browser