Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
preminqlik
Specialist II
Specialist II

Reverse accumulation but twist

Hello community icons ,  hope you guys will do it...

am attaching a document Please find it.

i want column E  output. which depends on F .

here column D is reverse accumulation wrt. to date....

its urgent 

advance thanks

prem

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Not applicable

Hi Prem

F Column is system Field or it is also calculated field.

Ananth

preminqlik
Specialist II
Specialist II
Author

it is also calculated....depends upon the previous of F record

Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand
Not applicable

Hi Gysbert,

In Case of remaining qty =0 , Qty should become 0 but it showing some value. can you pls check..

Thanks!!!!

preminqlik
Specialist II
Specialist II
Author

Thank you gysbert ....you are gem.........here i just kept condition to your backend script when >0 it works .....now it working perfect.....