Set Analysis - Intersection

Fri, 08 Jul 2011 14:36:47 GMT

Hi,

Can anyone help me on this. I am using Qlikview 8.5

Say i have a table with City and Zipcodes and distance as their fields. Please see the following

In the above i would like to have an intersection of two selections.

Selection1: EventName:A with distance less then 90. this will give me some zipcodes.(Book1)

Selection2: EventName:B with distance less than 96. this will have some zipcodes(Book2)

Now if i need to have an intersecting zipcodes of the above two sets, what expression i should use for this.

I have tried using the below expression

count(distinct {Book1*Book2}Zipcode).

But it does not work.

Please let me know if you can help me on this.

Thanks

Hari

Re: Set Analysis - Intersection

erichshiino — Tue, 12 Jul 2011 01:03:52 GMT

Hi,

I tried some similar expression and it worked for me: