Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MK9885
Honored Contributor II

Subtract 2 different rows from 2 different columns

Hi,

I've a requirement to create a new column based on subtracting 2 date columns

2019-11-25_133337.png

In above image, I'd like to get Turn around time by doing 10:30 - 10-45 and then 12:17 - 12:44

To create a new column with this...

Tried peek, above rangesum but doesn't seem to work.

Can anyone please tell me how to get TAT from previous time to current time in next row?

@sunny_talwar 

 

Thanks.

1 Solution

Accepted Solutions
Highlighted
MK9885
Honored Contributor II

Re: Subtract 2 different rows from 2 different columns

Maybe I found the solution...

Divided into 3 exp. not ideal but works

Exp1: above(Total (Column2))-(Column2)

Exp:2: below(Total (Column1))-(Column1)

Final Exp: below(Total ([Exp1]))-([Exp2])

View solution in original post

1 Reply
Highlighted
MK9885
Honored Contributor II

Re: Subtract 2 different rows from 2 different columns

Maybe I found the solution...

Divided into 3 exp. not ideal but works

Exp1: above(Total (Column2))-(Column2)

Exp:2: below(Total (Column1))-(Column1)

Final Exp: below(Total ([Exp1]))-([Exp2])

View solution in original post