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: 
qliklearnervir
Creator
Creator

want to set when one date should not have any matching interval in from date and to date in different table

Hi All,

I having one requirement where i have 2 tables.

Online Booking :

Online Booking Date,

Online Arrival Date,

Online Booking ID

;

Physical Arrival Table:

Arrival Date,

Departure Date;

I want the number of record from Online Booking table , where Online Arrival Date don't have any presence in between Physical Arrival Date.Arrival Date and Physical Arrival Date.Departure Date column.

simply i want the count of booking from online which don't have any arrival in physical arrival table.

even we can set a flag also in Online booking table.

please suggest the correct scenerio.

5 Replies
its_anandrjs

In this table both have any relation or not it seems there is no relation between they like Online Booking ID or some other fields check this in the Physical Arrival Table

Physical Arrival Table:

Arrival Date,

Departure Date;

qliklearnervir
Creator
Creator
Author

Yes: Email field is common in both the tables.

Online Booking :

Online Booking Date,

Online Arrival Date,

Email,

Online Booking ID

;

Physical Arrival Table:

Arrival Date,

Departure Date,

Email;



effinty2112
Master
Master

Hi,

Try:

Count({$<[Online Arrival Date] = {"<[Arrival Date]"}>*<[Online Arrival Date] = {">[Departure Date]"}>}[Online Booking ID])

Cheers

Andrew

its_anandrjs

Not any unique ID like  Online Booking ID or ID.


qliklearnervir
Creator
Creator
Author

no.unique id.........

can we do it script.....

and generate non matching record..