topic First date after last date in QlikView

First date after last date

Anonymous — Thu, 27 Aug 2009 03:49:38 GMT

Have 2 tables both with a date field (linked on Pat), trying to return the first date from one table after the last date in the other table. Below is what I have so far. Acting like the IF doesn't apply to each Pat - which kind of makes sense. There isn't something like AggrIf?

Thanks!


aggr(min(if(Date2 > aggr(max(Date1), Pat), Date2)), Pat)

First date after last date

Wed, 02 Sep 2009 13:53:48 GMT

Hi Scott,

I think the solution is using the qualifier Total inside the internal aggregation.

See my attached file.

I hope this help you.

Best regards.

First date after last date

Anonymous — Wed, 09 Sep 2009 03:05:27 GMT

Hi Magv

Oh... Had high hopes!

But if you filter field1 to just A. You get different results for Patient 1/exp2 if you have all pats selected or just Patient 1 selected

Sorry for my delay - was on vacation

thanks!

First date after last date

Wed, 16 Sep 2009 14:58:48 GMT

Hi Scott,

I haven't surrendered by this challenge, so, I have a new solution for your problem using input fields, I don't know why qlikview does't allow the logical expression that you were made, but with the use of this objects I could calculate the max date of every pat then make the comparation like you need.

So, I hope again this works you.

Best regards.