Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to use Max Timestamp for measure expression

HI,

I am trying to use Max function along with timestamp function for calculation of measures, but getting an error in expression.

My expression is:-

Interval(

sum({<[reto]={'Correctly created'}>}


Timestamp(Timestamp#([edited date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')

-

Timestamp(Timestamp#([detail end date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')

)

,'hh')*24



Please suggest.

 

1 Reply
sunny_talwar

Can you check if the error goes away if you use this expression

=Sum({<[reto] = {'Correctly created'}>} (TimeStamp#([edited date time], 'YYYYMMDD hh:mm:ss') - TimeStamp#([detail end date time], 'YYYYMMDD hh:mm:ss'))) * 24