topic Joining two tables in qlikview script in QlikView

Joining two tables in qlikview script

AbhijitBansode — Thu, 16 Dec 2010 12:51:27 GMT

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;

Joining two tables in qlikview script

kaushalview — Thu, 16 Dec 2010 12:58:03 GMT

Hi,

Please Send ur Application File.

Joining two tables in qlikview script

AbhijitBansode — Thu, 16 Dec 2010 13:09:00 GMT

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

Joining two tables in qlikview script

Thu, 16 Dec 2010 13:18:09 GMT

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

Joining two tables in qlikview script

AbhijitBansode — Thu, 16 Dec 2010 13:48:18 GMT

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

Joining two tables in qlikview script

Thu, 16 Dec 2010 15:34:05 GMT

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

Joining two tables in qlikview script

kaushalview — Fri, 17 Dec 2010 08:30:23 GMT

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.

Joining two tables in qlikview script

AbhijitBansode — Wed, 22 Dec 2010 10:47:53 GMT

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