Show fields only if it obeys a rule

[#1]

Hi there,

I just started learning Qlikview and I am hoping someone could help me out with writing an expression. I have the following data in a straight table:

Airport     Airline     Number of Airlines (generated by counting distinct airline)

A               1                    3

B               1                    2

D               1                    1

A               2                    3

B               2                    2

C               2                    3

A               3                    3

C               3                    3

C               4                    3

So according to the data we can see that Airport A has airline 1, 2 & 3 flying to it, Airport B has airline 1 & 2, Airport C has 2, 3 & 4 and finally Airport D has only airline 1. If I wanted the airports to only show if 3 airlines were flying to it, in this case only Airport A and C should appear, how should I write the expression?

I really appreciate any help or feedback.

[anbu1984 · Accepted solution]

Check this qvw

[#3]

Thank you very much for your quick and helpful response, it was what I was looking for!