topic Counter functions in App Development

Counter functions

Nextle — Wed, 19 May 2021 13:02:24 GMT

Hello, please help me. How to assign a number in the script and in the diagram, as in the example shown. I tried to use the function "autonumber" and "rank" failed.

Example:

Thank you in advance.

Re: Counter functions

Qlik1_User1 — Wed, 19 May 2021 13:41:36 GMT

@Nextle ,

What is the criteria for assigning a number.

Re: Counter functions

Nextle — Wed, 19 May 2021 14:06:20 GMT

if the work of one surname = the work of another surname, their numbers are the same, and the next number is the previous +1. At the same time, in each new month, the rank starts from 1.

Re: Counter functions

Qlik1_User1 — Wed, 19 May 2021 14:55:35 GMT

@Nextle

Use RANK function on Work+Month this might resolve the issue.