Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Function similar to Previous at Front End

Hello Expert,

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

Regards,

Balraj

8 Replies
maxgro
MVP
MVP

maybe above

in Qlik online help inter record functions

MarcoWedel

or "before" in pivot tables

Anonymous
Not applicable
Author

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
Specialist II
Specialist II

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
Not applicable
Author

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
Master II
Master II

Hi balraj,

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

Regards

KC

Best Regards,
KC
MarcoWedel

Hi,

one possible solution:

QlikCommunity_Thread_135272_Pic1.JPG.jpg

QlikCommunity_Thread_135272_Pic2.JPG.jpg

QlikCommunity_Thread_135272_Pic3.JPG.jpg

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
Master II
Master II

Hi Marco,

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

Regards

KC

Best Regards,
KC