Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this solution

jonashertz
Contributor III
Contributor III
‎2023-09-21 12:00 PM

Try using the Rangesum() function with Peek(). Be aware of the apostrophes (') in peek and the Order of the table row is important!
 
Load 
rangesum(Flag,peek('Rangesum_script')) as Rangesum_script,
*;
 
Load * Inline [
Row PNR Flag Rangesum
1 2222 0 0
2 2222 1 1 
3 2222 0 1
4 2222 0 1
5 2222 1 2
6 2222 1 3
7 2222 0 3
8 2222 1 4
] (delimiter is '\t');

View solution in original post

1 user say ditto
529 Views
Who Me Too'd this solution