Discussion Board for collaboration on QlikView Scripting.
How can I access the previous data based on previous date condition where the value Exists?
I am making a table
FieldA FieldB Product
01-02-2013 234 A
02-03-2013 (234)+100 A
03-04-2013 (234+100)+100 A
Thanks in Advance,
What is the output you want from the above example?
Thanks for Reply,
Here my need is to Calculate FieldB
If you want in Script then,
Please go to Help -> Peek
Load A, B, NumSum( B, peek( 'Bsum' ) ) as Bsum...; creates an accumulation of B in Bsum.
It will help you , but before that u need to create a table which have only required field
If you want in Chart level,
Then use rangesum function.