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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
paolojolly
Creator
Creator

Rolling data in QlikView

Hi, I'm not very experienced with QlikView and I need help to create a rolling column in a pivot table.

In the pivot table I have stock movements and I'm using two variables to filter the movements by data. In the pivot I need to show the Initial Qty, the Qty for each movement and the final Qty.The result should look like this:

paolojolly_0-1762428876935.png

Can someone help me?

Thanks

 

Labels (4)
2 Replies
robert_mika
MVP
MVP

Try 

RangeSum( Above( Sum(QTY), 0, RowNo() )
 

 

Nagaraju_KCS
Specialist III
Specialist III

try this

Rangesum(Above(Total Sum(QTY),0,RowNo(TOTAL)))