Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

joining problem

Hi Team,

I am new to Qlikview. Here you go my question,

I have created two QVD files A & B the joining key is C, so now I wanted to join these two table and create subset. Below is the SQL code for that.

Select A.section,sum(B.sales) from A inner join B ON a.c=b.c Group by A.section;

Can any one help me to create same query in Qlikview assuming we have two QVD's.

Regards,

Joyking

2 Replies
Not applicable

joining problem

Hi Joy, welcome to the world of QlikView!

In Qlikview, the way things are done is different to SQL. you load the tables one at a time, chopping changing them as you load more information and then in the final document the joins are performed dynamically using fields that share exactly the same name. The resulting data set when displayed in a document is like looking at a "full outer" join as everything is returned.

What you want to do looks like you want to end up with a final table that is an intersection of A and B (only where they share the same C)

to do this, you need to load one table, then join using the inner join() command

Table1:

load

A,

A2,

C,

from C:\Qlikview\A.QVD (qvd);

inner join (Table1)

Load

B,

B2,

C

from C:\Qlikview\A.QVD (qvd);

Table 1 will now only contain the following: A,A2,C,B,B2 where the two tables shared a C.

You can also use a "keep" statement, see the helpfile for more exaplanation

Hope this helps,

Erica

vijay_iitkgp
Not applicable

joining problem

Hi,

In addition to Erica, You can first Inner Join two tables A and B on Key C and then Aggregate the values.

Eg:

Table1:

Load

Section,

C

From A.qvd;

Inner Join

Load

Sales,

C

From B.qvd;

Table2:

Noconcatenate

Load

Section,

Sum(Sales)

Resident Table1

Group By Section;

Drop Table Table1;

Hope this will help.

Regards

VIjay