Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Re: max date

Hi Sunny, have attachedtimestamp issue.png

Highlighted

Re: max date

Can you share the expression behind your second box which is showing null? Also, it seems you have two spaces between your date and time? Did you make sure that you took care of that in your interpretation function?

View solution in original post

Highlighted

Re: max date

Try this

timestamp_test.JPG

!

Highlighted

Re: max date

app attached

Contributor

Re: max date

Sunny, You are right.Space is the issue.

Used below expression. Removed space between YYYY and hh. Never knew it cause a problem. Thanks a ton.

TimeStamp(TimeStamp#(Left(Right('XYZ_20_11_2016_00_12.csv',20),16),'DD_MM_YYYY_hh_mm'),'MM/DD/YYYYhh:mm:ss TT')

Highlighted
Contributor

Re: max date

Hi Swe Tha

Max function is for number fieldd, so you have to convert this field to number or use maxstring as you mencioned above.

Good luck!