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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

RowNo() in table

Is it possible to display RowNo()  for only the specified items in the table?

ex)In table X, I want to assign row numbers only for Region, City and Sales data. I would like to ignore Customer data, is that possible?
----------------------------
Table X:
Region,
City,
Sales,
RowNo() as RowID,

Customer

resident City;

----------------------------

1 Reply
rubenmarin

Hi, I'm not sure to understand your question...maybe with Autonumber()?:

Autonumber(Region&'_'&City&'_'&Sales) as RowID

Using this, rows with the same region, city and sales will have the same ID.