Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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?

1 Solution

Accepted Solutions
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

25 Replies
dan_sullivan
Creator II
Creator II

is it possible that some of the data is null in your timestamp variable?

kmswetha
Creator
Creator
Author

It is a single file, stored in a variable? So no chance of null.

THe movement I use Max, it doesn't work

nilesh_gangurde
Partner
Partner

there is possibility that timestamp could be in text format.

use timestamp# function and get actual timestamp format.

Regards,

Nilesh

kmswetha
Creator
Creator
Author

ITS WORKING WHEN I USE MAX STRING

kmswetha
Creator
Creator
Author

EVEN THEN ITS NOT WORKING

nilesh_gangurde
Partner
Partner

share example in qvw or qvf

antoniotiman
Master III
Master III

What is the Filename ?

kmswetha
Creator
Creator
Author

for example you can use file name as

XYZ_20_11_2016_00_12.csv'

kmswetha
Creator
Creator
Author

timestamp(timestamp#(left(right('XYZ_20_11_2016_00_12.csv',20),16),'DD_MM_YYYY_HH_MM'),'MM/DD/YYYY hh:mm:ss TT')