Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor 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
Highlighted
Partner
Partner

Re: count up function

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

Autonumber(orderID, CustomerID) as count_up_rows

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: count up function

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

Autonumber(orderID, CustomerID) as count_up_rows

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor II

Re: count up function

it works ! Thank you so much!