Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to use this date/time format then work out the difference.

Hello,

So I have a CSV which auto exports as DD-MM-YY HHSmiley FrustratedS TT. (01-01-16 11:01 PM).

I have two time fields, Date created and date resolved - I want to be able to work out the average difference between these.

Here is an example of my table

Date CreatedDate Resolved
01-01-16 1:01 AM02-01-16 4:01 AM
01-01-16 2:01 AM03-01-16 5:01 AM
01-01-16 3:01 AM04-01-16 6:01 AM

Thanks in advance!

(This is all on QlikSense NOT Qlik View)

3 Replies
MVP
MVP

Re: How to use this date/time format then work out the difference.

avg(Timestamp#([Date Resolved], 'DD-MM-YY HHSmiley FrustratedS TT') - Timestamp#([Date Created], 'DD-MM-YY HHSmiley FrustratedS TT'))

Vegar
Valued Contributor

Re: How to use this date/time format then work out the difference.

If you put interval() around maxgro‌'s expression it will be presented in a readable format.

Interval( avg(Timestamp#([Date Resolved], 'DD-MM-YY HHSmiley FrustratedS TT') - Timestamp#([Date Created], 'DD-MM-YY HHSmiley FrustratedS TT')) )

Re: How to use this date/time format then work out the difference.

Would you let me know what is the expected output for it

Community Browser