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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Looping Data to Create Incremental Counts

I have a similar problem as in the following post: http://community.qlik.com/forums/p/23725/90696.aspx#90696.

I have a table like Table1: ID, SCORE, and COUNT. COUNT is a count of students with that score.

I need to convert the data in Table1 into multiple records like in Table2. Each ID will have its own set of incremental counts (INCR).

Any assistance in resolving this is appreciated!

Table1:
IDSCORECOUNT
1098383621
1098383633
1098387022
1098387032
Table2:
IDSCOREINCR
1098383621
1098383632
1098383633
1098383634
1098387021
1098387022
1098387033
1098387034


0 Replies