Matching and Count data from 2 Column

[#1]

Hello guys, I'm a new user to qliksense

I want to ask how can you match between two column without define the value?

I want to count and find out if there's a difference in date with the same booking code (All Booking Code must have same Flight Date)

Below is an example of the data:

BOOKING CODE	Flight Date
A5N1	01/01/2017
A5N1	01/01/2017
A5N2	01/02/2017
A5N2	01/02/2017
A5N2	01/03/2017
A5N3	01/03/2017
A5N3	01/03/2017

Thank you so much for your help guys!

[sunny_talwar]

May be like this:

Dimension

[BOOKING CODE]

Expression

If(Count(DISTINCT [Flight Date]) > 1, 'Multiple Flight Dates', 'Single Flight Date])

This will help you identify if you have multiple or single date/s for each booking code