topic Re: How can I access the previous data based on previous date condition where the value Exists? in QlikView

How can I access the previous data based on previous date condition where the value Exists?

Mon, 11 Nov 2013 11:35:11 GMT

Hello Everyone,

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

Please help.

Thanks in Advance,

qliksus — Mon, 11 Nov 2013 11:37:22 GMT

Hi,

What is the output you want from the above example?

Mon, 11 Nov 2013 12:04:56 GMT

Hi qliksus,

Thanks for Reply,

Here my need is to Calculate FieldB

qliksus — Mon, 11 Nov 2013 12:15:27 GMT

Hi,

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.