topic Re: difficult get value max date from datetime column in QlikView

difficult get value max date from datetime column

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

Hi,

My qvd data is coming form txt file and I want to get a max date from Record_Updated_Datetime. But when I try I get this value for particular column I am not able to select datetime column. I am getting concatebate of all columns. Please refer below screen shot.

But when I try to put that column in text object in throwing as bad fields name.

Please help me on this how to get max date on this column.

Regards,

Kumar

Re: difficult get value max date from datetime column

kaushiknsolanki — Mon, 18 Jun 2018 06:12:39 GMT

HI,

This means that your data is not loaded properly. Make sure that you have used correct delimiter while loading the data.

Regards,

Kaushik Solanki

Re: difficult get value max date from datetime column

Anonymous — Mon, 18 Jun 2018 08:06:09 GMT

Hi Kaushik,

Thanks for your reply.

Can you tell me which delimiter should I use to get proper O/P fields.

Regards,

Kumar

Re: difficult get value max date from datetime column

Anonymous — Mon, 18 Jun 2018 09:16:16 GMT

I got solution.

Re: difficult get value max date from datetime column

avinashelite — Mon, 18 Jun 2018 09:44:39 GMT

If you have got the solution , close this thread by marking correct answer

Re: difficult get value max date from datetime column

Anonymous — Mon, 18 Jun 2018 11:36:49 GMT

Hi,

you can try the expression given below:

=max(date(HireDate,'DD/MM/YYYY'))