Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i want to filter data based upon two tables, for this i need to perform join query in database level.
but, i want to achieve the same at qlikview modelling level . pls hepl me how to achieve this.
below is the query i'm using at database level and its producing desired results:
SELECT
B.RECYM,
B.PRODUCT,
B.SALESORDER,
A.ADJST_RNTL_AMNT-B.ADJST_RNTL_AMNT
FROM
CANCL_AMT A,
TEMP B
WHERE
B.RECYM=(A.RECYM+1) AND
B.PRODUCT=A.PRODUCT AND
B.SALESORDER=A.SALESORDER;
I'm not sure if this fits to your needs but I attached the qvd file with the solution
Hi,
Please Send ur Application File.
Hi , i'm totally new to QlikView, i've tried using resident concept in QlikView but resident is not working on two tables .
.
should be something like:
A:
SQL SELECT
RECYM+1 as RECYM,
PRODUCT,
SALESORDER,
ADJST_RNTL_AMNT as A.ADJST_RNTL_AMNT
FROM CANCL_AMT;
B:
left join (A)
Load
RECYM,
PRODUCT,
SALESORDER,
ADJST_RNTL_AMNT as B.ADJST_RNTL_AMNT ;
SQL SELECT
RECYM,
PRODUCT,
SALESORDER,
ADJST_RNTL_AMNT
FROM
TEMP;
qualify *;
RESULT_TBL:
load
RECYM,
PRODUCT,
SALESORDER,
A.ADJST_RNTL_AMNT - B.ADJST_RNTL_AMNT as ADJST_RNTL_AMNT
resident
A;
But to see if it works I need sample records of the tables
Regards,
Björn
Hi, thanks for reply , i've attached exel file with this containing test data.
I'm not sure if this fits to your needs but I attached the qvd file with the solution
Hi,
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.
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..