Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kmswetha
Creator
Creator

max date

Hi,

I'm having a file name where I'm extracting date along with time stamp, using timestamp(timestamp(filename)). So far is good.

How ever when I say max  of that field, it returns' -.'

Not sure whats happening.

Any suggestions pls?

25 Replies
kmswetha
Creator
Creator
Author

Hi Sunny, have attachedtimestamp issue.png

sunny_talwar

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

colin_albert

Try this

timestamp_test.JPG

!

colin_albert

app attached

kmswetha
Creator
Creator
Author

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')

juan_patrick
Creator
Creator

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!