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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use row no functin in chart

can we use row no . function in  front end

6 Replies
Not applicable
Author

i have to add sequence 1,2 ,3 in a chart

sunny_talwar

Yes RowNo() can be used in front end objects.

Not applicable
Author

Hi,

RowNo() is also a Chart function, so you can use it in an expression to return the sequential row number (starts at 1) for the current veritical dimension.  Or use RowNo(total) to get the overall sequential number.


sunny_talwar

You can use this =RowNo(TOTAL) to get what you are looking for. Please find attached a sample for your reference.

Capture.PNG

HTH

Best,

Sunny

Not applicable
Author

is it possible to use it in calculated dimension

sunny_talwar

Yup, you can try this as your dimension in my above sample:

=Aggr(RowNo(), Dim)