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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stephbzr
Contributor III
Contributor III

Increment values

Hello,

 

I need to increment a value at a certain condition (when column "entite" equals 070), which I can do with the tMap :

 

0695b00000bE1QpAAK.png 

0695b00000bE1SCAA0.png0695b00000bE1SvAAK.png 

But what I would like now is that the other lines keep the value until the next increment. And I don't know what method can help me to do that ?

0695b00000bE1bTAAS.png

Labels (4)
1 Solution

Accepted Solutions
jlolling
Creator III
Creator III

Simply replace the last "" with String.valueOf(row1.id_hist_nextval)

 

View solution in original post

2 Replies
jlolling
Creator III
Creator III

Simply replace the last "" with String.valueOf(row1.id_hist_nextval)

 

stephbzr
Contributor III
Contributor III
Author

Thank you! I just had to add - 1 to have the same value, I do not know why, but the result is good 

 

0695b00000bECRtAAO.png