Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
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

25 Replies
Highlighted
Creator II
Creator II

Re: max date

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

Highlighted
Creator
Creator

Re: max date

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

THe movement I use Max, it doesn't work

Highlighted
Partner
Partner

Re: max date

there is possibility that timestamp could be in text format.

use timestamp# function and get actual timestamp format.

Regards,

Nilesh

Highlighted
Creator
Creator

Re: max date

ITS WORKING WHEN I USE MAX STRING

Highlighted
Creator
Creator

Re: max date

EVEN THEN ITS NOT WORKING

Highlighted
Partner
Partner

Re: max date

share example in qvw or qvf

Highlighted
Master III
Master III

Re: max date

What is the Filename ?

Highlighted
Creator
Creator

Re: max date

for example you can use file name as

XYZ_20_11_2016_00_12.csv'

Highlighted
Creator
Creator

Re: max date

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