Set Analysis - Intersection

[#1]

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

City	Zipcode	Distance
A	1	92
A	2	85
A	3	101
A	4	89
A	5	75
A	6	78
A	7	58
B	1	95
B	2	89
B	3	90
B	4	100
B	5	91
B	6	75
B	7	77
B	8	65
B	9	105

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

[erichshiino]

Hi,

I tried some similar expression and it worked for me: