topic Re: Where condition in set analysis in QlikView

Where condition in set analysis

srik00001 — Wed, 10 Jun 2015 00:15:19 GMT

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

Re: Where condition in set analysis

ToniKautto — Wed, 10 Jun 2015 00:26:33 GMT

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.

Re: Where condition in set analysis

srik00001 — Wed, 10 Jun 2015 03:42:04 GMT

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