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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 🙂