topic Re: Function similar to Previous at Front End in QlikView

Function similar to Previous at Front End

Anonymous — Sat, 27 Sep 2014 06:37:37 GMT

Hello Expert,

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

Regards,

Balraj

Re: Function similar to Previous at Front End

maxgro — Sat, 27 Sep 2014 07:53:35 GMT

maybe above

in Qlik online help inter record functions

Re: Function similar to Previous at Front End

MarcoWedel — Sat, 27 Sep 2014 07:55:11 GMT

or "before" in pivot tables

Re: Function similar to Previous at Front End

Anonymous — Sat, 27 Sep 2014 08:08:01 GMT

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

Re: Function similar to Previous at Front End

sundarakumar — Sat, 27 Sep 2014 08:23:41 GMT

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

Re: Function similar to Previous at Front End

Anonymous — Sat, 27 Sep 2014 08:29:46 GMT

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????

Re: Function similar to Previous at Front End

jyothish8807 — Sat, 27 Sep 2014 08:32:35 GMT

Hi balraj,

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

Regards

Re: Re: Function similar to Previous at Front End

MarcoWedel — Sat, 27 Sep 2014 08:54:23 GMT

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

Re: Function similar to Previous at Front End

jyothish8807 — Sat, 27 Sep 2014 09:13:10 GMT

Hi Marco,

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

Regards