Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joshuahirsch
Partner - Contributor III
Partner - Contributor III

Add a custom resetting Minute (Counter) Field in Table

Hello everybody,

 

So I want to have the minute to every Field in the Array (see below) like there would be the index of the field.

So its a resetting counter, which resets everytime, a new KEY_marker is different.

 

Desired OutputDesired Output

 

 

Load Script with some testing:

Data comes from REST as JSON, its an Array like that:

"MASTER_DATA_DEVICE_ID": "",
"cpr_sum": [null,null,null, 88, 99, 87],
   ..."

From JSON RESTFrom JSON REST

 

Feels like im close, but don't know further

Labels (2)
1 Solution

Accepted Solutions
joshuahirsch
Partner - Contributor III
Partner - Contributor III
Author

Ah nevermind, I knew i was close.

     autoNumber(RowNo(),[__FK_cpr_sum]) as autoMinute

did the trick 🙂

 

 

View solution in original post

1 Reply
joshuahirsch
Partner - Contributor III
Partner - Contributor III
Author

Ah nevermind, I knew i was close.

     autoNumber(RowNo(),[__FK_cpr_sum]) as autoMinute

did the trick 🙂