topic Re: Issue with Min Time Fraction for the Max Date in QlikView

Issue with Min Time Fraction for the Max Date

rustyfishbones — Fri, 28 Feb 2014 10:39:48 GMT

Hi All,

I have the following Expression (It say Expression is OK, but it's not)

What I need is the Minimum Start Time for the Maximum Date

The expression works fine until I add the max date part

{<Date = {"$(=MAX(Date))"}>} (This works fine for other expression where I want to sum values for the max date)

Any idea what I could be doing wrong here

alexandros17 — Fri, 28 Feb 2014 10:45:27 GMT

Try

Date = {"$(=Date(MAX(Date)))"}

rustyfishbones — Fri, 28 Feb 2014 10:54:18 GMT

Hi,

My Date is formatted correctly as it is working in other expressions

could it be I can't do this while using the TIME or FRAC part?

rustyfishbones — Fri, 28 Feb 2014 10:55:32 GMT

Hi All,

I got this working with the following expression

Regards

Alan

MK_QSL — Fri, 28 Feb 2014 10:58:29 GMT

=TIME(Min({1}{<Date = {'$(=Date(Max(Date)))'}>}StartTime),'hh:mm:ss')

rustyfishbones — Fri, 28 Feb 2014 11:12:20 GMT

Thanks Manish that also works