Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Can someone help me?
Thanks
Try
try this
Rangesum(Above(Total Sum(QTY),0,RowNo(TOTAL)))