Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Nextle
Contributor
Contributor

Counter functions

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.

Nextle_0-1621429185117.png

Example:

Nextle_1-1621429303324.png

Thank you in advance.

3 Replies
Qlik1_User1
Specialist
Specialist

@Nextle ,

What is the criteria for assigning a number.

Nextle
Contributor
Contributor
Author

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.

Qlik1_User1
Specialist
Specialist

@Nextle 

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