topic Re: max date issue in QlikView

max date issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to get max datetime value form QVD.

But it is giving blank in text object. In database the value is like below. Can anyone suggest on this issue

In qlikview

Regards,

Kumar

Chanty4u — Mon, 18 Jun 2018 09:47:06 GMT

try this

Timestamp(max(DateField),'YYYY-MM-DD hh:mm:ss')

Chanty4u — Mon, 18 Jun 2018 09:48:35 GMT

i think your date field coming as text.

add your date field in listbox and send screen shot.

Anonymous — Mon, 18 Jun 2018 10:20:49 GMT

Thanks for your reply. I tried with that formula but it is not working.

Regards,

Kumar

Chanty4u — Mon, 18 Jun 2018 10:21:48 GMT

it is coming as text . thats why it is showing " -"

Anonymous — Mon, 18 Jun 2018 10:23:27 GMT

I tried with below value

=max(timestamp(timestamp#(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))).

But it is giving me PM at end of the value like . I want to exclude PM in that result

Anonymous — Mon, 18 Jun 2018 10:24:38 GMT

I don't understand how are you saying that it is text value. Can you tell me.

Chanty4u — Mon, 18 Jun 2018 10:25:10 GMT

try this

=max(timestamp(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))

Anonymous — Mon, 18 Jun 2018 10:26:29 GMT

I tried with that already.

Anonymous — Mon, 18 Jun 2018 11:08:32 GMT

I got solution using below expresssion.

=purgechar(max(timestamp(timestamp#(Record_Updated_Datetime,'DD/MM/YYYY hh:mm:ss'))),'AMP')