Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show fields only if it obeys a rule

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.

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

2 Replies
anbu1984
Master III
Master III

Check this qvw

Not applicable
Author

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