Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbhijitBansode
Specialist
Specialist

Joining two tables in qlikview script

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;

1 Solution

Accepted Solutions
Not applicable

I'm not sure if this fits to your needs but I attached the qvd file with the solution

View solution in original post

7 Replies
kaushalview
Partner - Creator II
Partner - Creator II

Hi,

Please Send ur Application File.

AbhijitBansode
Specialist
Specialist
Author

Hi , i'm totally new to QlikView, i've tried using resident concept in QlikView but resident is not working on two tables .

.

Not applicable

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

AbhijitBansode
Specialist
Specialist
Author

Hi, thanks for reply , i've attached exel file with this containing test data.

Not applicable

I'm not sure if this fits to your needs but I attached the qvd file with the solution

kaushalview
Partner - Creator II
Partner - Creator II

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.

AbhijitBansode
Specialist
Specialist
Author

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