Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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