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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting previous row and totals

Hi i have a situation whereby i would like to accumulate in my column and present the total in the totals row.

I have 3 expressions

1. Order

2. Stock

3. Purchase Orders

4. Available Stock is calculated as follows (Stock - Order + Purchase Orders)

Stock is always at the level that you see now so for example 50 for Art No. 100.

Art No. Date
Stock (right now)OrderPurchase OrderAvailable Stock
1002013-10-20502000-150
1002012-11-2050300200-250
Total Art No-50500200-250
2002013-09-1530251015
2002013-10-20301005
Total Art No-3035105

Best Brad

0 Replies