TAT

[Prabhu1204]

Hello All,

Could you please help me in below scenario,

I have a Document and for each document there will be a phase.. Phase are calculated by difference of start and end date.

But for calculating Turn around time i need to subtract the value with the previous phase value. how to do that in UI

For example : Contract is 1 , Review should be 2-1 = 1, Approval should be 6-2=4 like this

[justISO]

Hi,

not sure is it working in QlikView the same, but in QlikSense I would try

[yourmeasure]-Before([yourmeasure])

[Prabhu1204]

Will this work in straight table also.. In Pivot table due to sorting the values are not coming as expected

My Sequence should be :  Contract Draft, Review,Approval, Signature, Finalize and Close.

[justISO · Accepted solution]

If it is not complicated and will not brake anything else, you can add numbers before your phases (like '1. Contract Draft', '2. Review' ...). This way you will not lose sorting.

About straight tables, instead 'Before', just use 'Above'.

And one last thing, not to lose first value from result, lets modify my suggested formula with a little tweak:

if (isnull(Before([yourmesure])),[yourmesure], [yourmesure]-Before([yourmesure]))

[Prabhu1204]

Thanks  a lot