Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
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

Highlighted
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!