How to Rank Approval Activities?

[pentaxadmin]

Dear Community,

I am struggling with the last part of my script and need help.

I have  task with 5 approval process activities. I need to create a calculated dimension '1st, 2nd, 3rd, .... Approver' based on the time when they approved the task.

Please see attached example.

Thanks in advance for your help.

Branislav

Task.Id	Activity.Date	Activity.Id	TaskOwner.Name	TaskOwner.Title	ActivityActor.Id.Name	Activity.Status	ApproverLevel	Notes
12345678	8/24/2015 22:49	A_000001	ABC	Rep1	AA	AUTO APPROVAL	N/A'	Do not want to count auto approvals
	8/24/2015 23:24	A_000010	ABC	Rep1	BB	MANUAL APPROVAL	1st Approver	Sorted by Activity.Date
	8/25/2015 1:05	A_001000	ABC	Rep1	CC	MANUAL APPROVAL	2nd Approver	Sorted by Activity.Date
	8/25/2015 3:10	A_001100	ABC	Rep1	DD	MANUAL APPROVAL	3rd Approver	Sorted by Activity.Dat

[pentaxadmin]

‌I want to correct my previous statement. What I was trying to explain in my original thread is that I have 1 activity with multiple tasks of approval. I need to assign a dimension '1st approved', '2nd approved and so on based on the task create date, excluding auto approvals

[idogridish2]

Hi,

May be:

=aggr(only({$<Activity.Status-={'AUTO APPROVAL'}>}Activity.Date),Activity.Date)

See the Attached.

[ramoncova06]

you can do this at script level with peek, you could also do this in the front end though you would always need them to be sorted on the correct way, limiting the graph/table functionality

here is a link

Create Sequence Number | Qlik Community

[pentaxadmin]

First Example doesn't seem to work. I am looking into another one.

My Field Output Should look like

ActivityID, TaskID, TaskCreateDate, TaskStatus, ApproverRank

001,001-01,01/01/2016 00:00:00, Manual, 0

001,001-02,01/01/2016 05:25:44, Manual, 1st Approved

001, 001-03, 01/02/2016 10:15:25, Manual, 2nd Arroved

.....

Also, I would like to have it in the script as a dimension