topic Re: count up function in QlikView

count up function

thanhphongle — Sat, 31 Aug 2019 08:19:57 GMT

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)

Thank you for your help.

Vegar — Sat, 31 Aug 2019 08:50:04 GMT

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

Autonumber(orderID, CustomerID) as count_up_rows

thanhphongle — Sat, 31 Aug 2019 10:07:44 GMT

it works ! Thank you so much!