Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pentaxadmin
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.

Branislav

         

Task.IdActivity.DateActivity.IdTaskOwner.NameTaskOwner.TitleActivityActor.Id.NameActivity.StatusApproverLevelNotes
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
pentaxadmin
Partner - Creator
Partner - Creator
Author

‌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
Creator II
Creator II

Hi,

May be:

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

See the Attached.

ramoncova06
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

pentaxadmin
Partner - Creator
Partner - Creator
Author

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