Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
FrederikV
Contributor
Contributor

Problem using RowNo (chart function) to add an incremental ID column in a Table

Hello,

As I was creating a table, I wanted to add an ID column to check some calculations.

I add a new dimension with the following formula:

 

=RowNo(Total)

 

However this new column doesn't show any value, as shown here:

Capture d’écran 2021-01-22 183749.png

Could you help me to understand why there isn't any value and how I could correct my function?

Thanks in advance

1 Solution

Accepted Solutions
Anil_Babu_Samineni

I see that you have added as dimension, can you switch to Measure and see?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

I see that you have added as dimension, can you switch to Measure and see?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
FrederikV
Contributor
Contributor
Author

You're right, it works now.

That's weird. I tried it before but it didn't work neither. I don't remember what I exactly did,

Thanks a lot for you're fast reply!