Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Hello Everyone,

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

Like

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,

3 Replies
qliksus
Valued Contributor

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

Hi,

What is the output you want from the above example?

Not applicable

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

Hi qliksus,

Thanks for Reply,

Here my need is to Calculate FieldB

qliksus
Valued Contributor

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

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.

Community Browser