Tenure Calculation

[Anku]

Hi all,

I need your help.

I have a data which consists request id movements into different departments and respective Date.

Sample:

I want to calculate tenure of each unique request id but not overall, instead the tenure that unique id spent at last department.

Output:

I am new to Qlik-sense, please help me how to do it in Qlik-sense.

Thank you!

[JordyWegman]

Hi Anku,

If you use Request ID and Department in your table, you can use the following measure:

Max( Date ) - Min( Date )

Jordy

Climber

[Kushal_Chawda · Accepted solution]

@Anku  looks like this is duplicate thread

https://community.qlik.com/t5/App-Development/Request-Age-Calculation/m-p/1835410#M69013

[Anku]

@JordyWegman  Thanks mate for your response.