Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anku
Creator
Creator

Request Age Calculation

Hi all,

I need your help.

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

Sample:

Anku_2-1631356369170.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_3-1631356369173.png

 

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

Thank you!

10 Replies
Anku
Creator
Creator
Author

@Kushal_Chawda  You're master buddy. Thank you so much.