Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Partner - Creator
Partner - Creator

How to Rank Approval Activities?

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.



123456788/24/2015 22:49A_000001ABCRep1AAAUTO APPROVALN/A'Do not want to count auto approvals
8/24/2015 23:24A_000010ABCRep1BBMANUAL APPROVAL1st ApproverSorted by Activity.Date
8/25/2015 1:05A_001000ABCRep1CCMANUAL APPROVAL2nd ApproverSorted by Activity.Date
8/25/2015 3:10A_001100ABCRep1DDMANUAL APPROVAL3rd ApproverSorted by Activity.Dat
4 Replies
Partner - Creator
Partner - Creator

‌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

Creator II
Creator II


May be:

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

See the Attached.

Specialist III
Specialist III

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

Partner - Creator
Partner - Creator

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