Function similar to Previous at Front End

[Anonymous]

Hello Expert,

Is their any function which works similar to Previous() function at front end???

Regards,

Balraj

[maxgro]

maybe above

in Qlik online help inter record functions

[MarcoWedel]

or "before" in pivot tables

[Anonymous]

Can anybody help me to get this??

Date         Initial Value     Sales          ClosingValue

Apr-14        50                   10                 60

May-14        60                  30                 90

June-14       90                  -20                70

Regards,

Balraj

[sundarakumar]

in back end.

load

date,

initial_value,

sales,

initial_value+sales as closing_value

from

xyz;

in front end

sum(initial_value)sum(sales) in the expression of closing value.

-Sundar

[Anonymous]

Its fine but I am asking how I can replace Initial Value by last Closing Value????

Here Initial Value is one time  Dynamic value which I am capturing in variable.

Say, for April I captured Initial Value but for month May closing Value of April will be a Initial Value of May.

Did u get????

[jyothish8807]

Hi balraj,

Sorry i couldn't find a way.Tried it.

Regards

KC

[MarcoWedel]

Hi,

one possible solution:

tabSales:
LOAD Date#(Date, 'MMM-YY') as Date,
    Sales
Inline [
Date, Sales
Jan-14, 20
Feb-14, 10
Mar-14, 20
Apr-14, 10
May-14, 30
Jun-14, -20
Jul-14, 10
Aug-14, 40
Sep-14, 30
];

hope this helps

regards

Marco

[jyothish8807]

Hi Marco,

He need 50 as his first entry also which is variable.How to get that?

Regards

KC