should be something like:
RECYM+1 as RECYM,
ADJST_RNTL_AMNT as A.ADJST_RNTL_AMNT
left join (A)
ADJST_RNTL_AMNT as B.ADJST_RNTL_AMNT ;
A.ADJST_RNTL_AMNT - B.ADJST_RNTL_AMNT as ADJST_RNTL_AMNT
But to see if it works I need sample records of the tables
First u go through the QlikView tutorial and understand each and every syantax in Qlikview so nu can easily understand how to perform join.
i have attached example file
just check it.
Test.qvw 120.0 K
Hi thanks for reply ,
this time i've got the solution using approaches/ideas suggested by u ..
since i'm new to the qlikview, currently more concetrating on studying and understanding features of it..,going through the qlikview refernce manual...
i've not found any topic regarding in memory working of qlikview .. can any one suggest me on the same..