Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Matching and Count data from 2 Column

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 CODEFlight Date
A5N101/01/2017
A5N1

01/01/2017

A5N201/02/2017
A5N201/02/2017
A5N201/03/2017
A5N301/03/2017
A5N301/03/2017

Thank you so much for your help guys!

1 Reply
sunny_talwar
Not applicable

Re: Matching and Count data from 2 Column

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