Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
alexandermllr
Creator
Creator

Timestamp Format problem

Hello,

I have a problem wih the timestamp format, this is my script:

if(Start_time = 'leer',Previous(Start_time )-Time(1/1440,'mm'),(Start_time )) as Start_time,


I always get the previous time - 1 min not in a timestamp format.

Start_time.PNG

How can I get always a timestamp?

Thank you!

1 Solution

Accepted Solutions
prieper
Master II
Master II

TIMESTAMP is just a formatting. Calculation itself is done on pure numbers.

Suggest to use

TIMESTAMP(if(Start_time = 'leer',Previous(Start_time )-(1/1440),(Start_time ))) as Start_time

instead.


Peter

View solution in original post

2 Replies
prieper
Master II
Master II

TIMESTAMP is just a formatting. Calculation itself is done on pure numbers.

Suggest to use

TIMESTAMP(if(Start_time = 'leer',Previous(Start_time )-(1/1440),(Start_time ))) as Start_time

instead.


Peter

alexandermllr
Creator
Creator
Author

Thank you very much !!