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
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rpsrathete
Contributor II
Contributor II

Aggr Function Help

Reschedule-Route Example.PNG


I am trying to flag '1' when there is Operation/Transaction of  "Reschedule or Route" for the first time in a given Task ID (as shown in the above) and then sum the number of such records for each LockedBy_IR in separate column.

In the above example, the sum for TGARCIA should be 1 and 0 for rest of the LockedBy_IR.

Any help will be really appreciated.

Thank you in Advance.

3 Replies
ogautier62
Specialist II
Specialist II

Hi,

try this :

if(row_counter =

aggr(nodistinct min(if(operation = 'route' or operation = 'reschedule',row_counter)),task_id),

1,0)

regards

sunny_talwar

Would you be able to share a sample to have a look and test it out?

rpsrathete
Contributor II
Contributor II
Author

I won't be able to share data.

I am sorry, for late response I didn't get the notification email about the comments on my thread.