Max Date function not working

[#1]

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

[MayilVahanan]

HI

Try like this

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

Hope it helps

[#3]

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

[#4]

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

[#5]

Hi,

You can try this expression.

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

Regards,

Janzen

[#6]

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

[MayilVahanan]

Hi

Please check the attached file

[whiteline]

Hi.

You can also use this one:

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