Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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!