Select a Field with max Date Between two other dates

Tue, 04 Jul 2017 13:00:27 GMT

Hi Folks,

Please help me, I'm getting mad.

I have two tables...

Moviment table - which has the hospital section and the date/Hour that the pacient was moved.. and

Collect table - which has the kind of vital signs, and the date/hour that it was collected...

I need to report where was the pacient when each vital sign was collected.

I thought to take the max Date of Moviment table between the previous Collect Date and the actual Collect date. But I don't even know how to do it.

Anyone has an Idea?

Re: Select a Field with max Date Between two other dates

MK_QSL — Tue, 04 Jul 2017 13:08:13 GMT

I think IntervalMatch function at script will help you on this.

Can you provide few lines of sample data for both tables.. (around 5 to 6 lines with two different patients)

Also provide the output you needed

topic Select a Field with max Date Between two other dates in QlikView

Select a Field with max Date Between two other dates

Re: Select a Field with max Date Between two other dates