topic Re: Intersection / Set analysis in QlikView

Intersection / Set analysis

Anonymous — Fri, 06 Dec 2013 16:19:13 GMT

I need some help with the following: My goal is to find clients who bought Cat1 product also bought Cat2 products.

1. I have the data in one table as give below:

I need a output as the followng :

After selecting Cat1, I need to show only the following record. Any suggestions?

Cat2

Client1

500

thanks !

Gysbert_Wassenaar — Fri, 06 Dec 2013 16:33:34 GMT

See attached qvw.

Anonymous — Fri, 06 Dec 2013 17:17:27 GMT

This is great ! How do I add one more field called "zip code" in addition to ClientAdd if required. (See below)

Is the following correct? or do I have to use some other operator?

({<[Prod Cat]={'Cat2'},[Client Add]=p({<[Prod Cat]=p([Prod Cat])>}[Client Add]),[Zip Code]=p({<[Prod Cat]=p([Prod Cat])>}[Zip Code])>}TeamSales)

Gysbert_Wassenaar — Sat, 07 Dec 2013 11:36:08 GMT

I don't understand what you're trying to do. Can you explain what the result should be and why?

Anonymous — Sun, 08 Dec 2013 04:51:18 GMT

If I had an additional column called zip and would like to still get the same result.

Result:

Cat2

Client1

10001

500