Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Minus Datetime

I have a trouble with minusing 2 datetime field. Can anyone help me to solve this problem, please? i will attached my file into this thread.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Minus Datetime

I would avoid aggr() and use:

=Interval(Sum(ClosedDate-CreatedDate , CaseCode), 'D hh:mm:ss')

Corrected

View solution in original post

5 Replies

Re: Minus Datetime

May be this:

=Interval(Sum(Aggr(ClosedDate-CreatedDate, CaseCode)), 'D hh:mm:ss')


Capture.PNG

Highlighted
MVP
MVP

Re: Minus Datetime

I would avoid aggr() and use:

=Interval(Sum(ClosedDate-CreatedDate , CaseCode), 'D hh:mm:ss')

Corrected

View solution in original post

Re: Minus Datetime

I guess you are right . Just a minor correction though, you forgot to remove the aggregated dimension from my expression:

=Interval(Sum(ClosedDate-CreatedDate), 'D hh:mm:ss')

HirisH_V7
Honored Contributor

Re: Minus Datetime

Hi,

May be like this,

Minus Time.PNG

Three expressions,

Interval(ClosedDate-CreatedDate,'DD')

Interval(ClosedDate-CreatedDate,'h')

Interval(ClosedDate-CreatedDate,'mm')

Hope this helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Not applicable

Re: Minus Datetime

Thank all very much