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: 
thanhphongle
Creator II
Creator II

count up function

Hello community,

is there a function where I can count up the rows group by customer_ID ?

Example: See the expected solution in the last column (count up rows)

customerIDorderIDorderdatequantityselling_pricecount_up_rows
1100101.01.201922001
1100215.01.201933002
1100301.08.201911003
2100415.01.20191101
2100530.06.20191202

 

 

Thank you for your help.

1 Solution

Accepted Solutions
Vegar
MVP
MVP

IF you have unique order ids then you can do this:

Autonumber(orderID, CustomerID) as count_up_rows

View solution in original post

2 Replies
Vegar
MVP
MVP

IF you have unique order ids then you can do this:

Autonumber(orderID, CustomerID) as count_up_rows

thanhphongle
Creator II
Creator II
Author

it works ! Thank you so much!