topic Re: Get date by comparing in another date field in QlikView

Get date by comparing in another date field

prasad — Sat, 16 Nov 2024 19:22:10 GMT

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

Re: Get date by comparing in another date field

Taoufiq_Zarra — Wed, 01 Jan 2020 12:07:53 GMT

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

Re: Get date by comparing in another date field

prasad — Wed, 01 Jan 2020 14:17:50 GMT

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

Re: Get date by comparing in another date field

Taoufiq_Zarra — Wed, 01 Jan 2020 14:50:09 GMT

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?

Re: Get date by comparing in another date field

prasad — Thu, 02 Jan 2020 02:29:03 GMT

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.

Re: Get date by comparing in another date field

prasad — Thu, 02 Jan 2020 04:02:28 GMT

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