topic TAT in QlikView

TAT

Prabhu1204 — Wed, 09 Mar 2022 06:45:00 GMT

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

Re: TAT

justISO — Wed, 09 Mar 2022 11:29:07 GMT

Hi,

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

[yourmeasure]-Before([yourmeasure])

Re: TAT

Prabhu1204 — Wed, 09 Mar 2022 13:38:07 GMT

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.

Re: TAT

justISO — Wed, 09 Mar 2022 14:00:04 GMT

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]))

Re: TAT

Prabhu1204 — Wed, 09 Mar 2022 15:06:25 GMT

Thanks a lot