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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
MVP
MVP

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