Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Expert,
Is their any function which works similar to Previous() function at front end???
Regards,
Balraj
maybe above
in Qlik online help inter record functions
or "before" in pivot tables
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
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
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????
Hi balraj,
Sorry i couldn't find a way.Tried it.
Regards
KC
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
Hi Marco,
He need 50 as his first entry also which is variable.How to get that?
Regards
KC