Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad
Contributor III
Contributor III

Get date by comparing in another date field

Hi,

I have 2 tables linked by unique id NRIC. One table has code and Joindate. The second table has Transactions Visit date.

I need to compare Transactions date to Joindate and check if Transactions date should be greater than the first date and lesser than the next join date. i have attached one sample, pls let us know how to achieve this. Thanks! in advance. Tks!

 

Prasad

 

 

 

1 Solution

Accepted Solutions
prasad
Contributor III
Contributor III
Author

Hi,  Thanks We got the solution using IntervalMatch. Tks!

View solution in original post

5 Replies
Taoufiq_Zarra
Master II
Master II

can you give more details on how you join the two tables ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
prasad
Contributor III
Contributor III
Author

Hi, by joining Nric field, i have attached the screen shot. Tks!

Taoufiq_Zarra
Master II
Master II

in the first line of the results file why 22/02/2005 became 22/02/2007
why there's more than one line of DB#

the result of a joint is not correct except if there is a logic behind it?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
prasad
Contributor III
Contributor III
Author

Yes Correct, the logic we need to check transaction date against Join dates, it should be in between the join dates ie, it should be lesser than the next join date and greater than the in between dates. same as the attached example. Tks! in advance. 

prasad
Contributor III
Contributor III
Author

Hi,  Thanks We got the solution using IntervalMatch. Tks!

View solution in original post