Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
preddy79
Contributor
Contributor

How to generate rank

Hi All,

I've similar requirement but i need to reset ranking at each student level for each subject

 

101 - Maths -1

101 - Science-2

101 - English-3

102 - Science-1

102 - English-2

 

I tried with sequence but it continues ranking to all students instead of getting reset at each student. Can any of you tried this please let me know.

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

You can use Numeric.sequence  in tMap to achieve your goal.

Please take a look at my screenshots for details

0683p000009Lrc4.png0683p000009LrcN.png

Let us know if it is OK with you.

Best regards

Sabrina