topic Calculate Max Value Between Two Timestamps in QlikView

Calculate Max Value Between Two Timestamps

salerik — Wed, 25 Nov 2020 16:16:04 GMT

Hello.

I have a column with timestamps and another column of values. I am looking to determine the maximum Value between the last (max) Timestamp and 24 hours ago. I am having trouble writing an expression for this. Can you please help? Thank you.

Re: Calculate Max Value Between Two Timestamps

sunny_talwar — Mon, 24 Aug 2020 14:09:54 GMT

What have you tried so far? Can you share some sample data and the output expected from it?

Re: Calculate Max Value Between Two Timestamps

sunny_talwar — Mon, 24 Aug 2020 14:14:24 GMT

Although you can try something like this

Max({<TimeStampField = {">=$(=TimeStamp(Max(TimeStampField) - 1, 'TimeStampFieldFormatHere'))<=$(=TimeStamp(Max(TimeStampField), 'TimeStampFieldFormatHere'))"}>} Value)