topic Re: Max Date function not working in QlikView

Max Date function not working

Thu, 27 Sep 2012 22:42:36 GMT

Hi Qlikview Community,

Could you please assist me in why this expression isn't working. The format of the DaysFilled.DateOriginal is yyyy-mm-dd 00:00:00.

sum({<DaysFilled.DateOriginal={"$(=max(DaysFilled.DateOriginal))"}>}DaysFilled.Days)

Thank you in advance,

OnePuttGirl

Hello,

I have tried everything that has been given. I thought I would include the .qvw and see if anyone can figure it out. The dates seem to be in the correct format. The object is Days Filled Detail and it is the only expression. Please help me it is really important that I get this done immediately.

Thank you,

Oneputtgirl

Re: Max Date function not working

MayilVahanan — Thu, 27 Sep 2012 22:46:13 GMT

Try like this

sum({<DaysFilled.DateOriginal={"$(=Date(max(DaysFilled.DateOriginal),'yyyy-mm-dd hh:mm:ss'))"}>}DaysFilled.Days)

Hope it helps

Re: Max Date function not working

Thu, 27 Sep 2012 22:49:01 GMT

I don't get anything with that expression. Any other ideas?

Re: Max Date function not working

Thu, 27 Sep 2012 22:54:21 GMT

I have even built a table box and got 'yyyy-mm-dd hh:mm:ss' format of DaysFilled.DateOriginal.

Re: Max Date function not working

Fri, 28 Sep 2012 02:24:02 GMT

Hi,

You can try this expression.

sum({<DaysFilled.DateOriginal={"$(=max(Date(Date#(DaysFilled.DateOriginal, 'yyyy-mm-dd hh:mm:ss')))"}>}DaysFilled.Days)

Regards,

Janzen

Re: Max Date function not working

Fri, 28 Sep 2012 14:34:40 GMT

Hi,

I attached a .qvw file to the original post can someone take a look at it and see if they can tell me whats going on. I can't see to get it to work and everything points to it should work.

Thank you,

Oneputtgirl

Re: Max Date function not working

MayilVahanan — Fri, 28 Sep 2012 19:34:57 GMT

Please check the attached file

Re: Max Date function not working

whiteline — Fri, 28 Sep 2012 20:13:00 GMT

Hi.

You can also use this one:

=sum({<DaysFilled.DateOriginal={"=DaysFilled.DateOriginal=max(DaysFilled.DateOriginal)"}>}DaysFilled.Days)