Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Anku
Contributor III
Contributor III

Tenure Calculation

Hi all,

I need your help.

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

Sample:

Anku_0-1631355758189.png

 

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

 

Output:

Anku_1-1631356074141.png

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

Thank you!

1 Solution

Accepted Solutions
3 Replies
JordyWegman
Partner
Partner

Hi Anku,

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

Max( Date ) - Min( Date )

 

Jordy

Climber

Work smarter, not harder
Anku
Contributor III
Contributor III
Author

@JordyWegman  Thanks mate for your response.