Solved: Greater than expression with timestamps - Qlik Community

Report Inappropriate Content · ‎2015-03-10

Hello!

I have a table with timestamps, timestamp 1 and timestamp 2. Now I want to count the timestamps where the difference between timestamp 1 and timestamp 2 is more than 2 minutes, the format of the timestamp is "hh:mm:ss".

Best Regards

Mårten

jonathandienst · ‎2015-03-10

Hi

Assuming these are valud QV timestamps, then timestamps are in units of a day (24 hours or 1440 minutes) and the format is not relevant.

For your question:

If(timestamp2 - timestamp1 > 2/1440, ...... , ......)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

PrashantSangle · ‎2015-03-10

Hi,

Use Count(if(Interval(timestamp1-timestamp2,'mm')>2,timestamps)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

jonathandienst · ‎2015-03-10

Hi