topic Re: Aggregate On Two Tables in QlikView

Aggregate On Two Tables

Anonymous — Tue, 28 May 2013 22:39:20 GMT

Is it possible to aggregate from two tables ?

For example, something similar to:

Table1:

Load

DocID,

DocType

From Tab1;

Table2:

Load

DocID,

AltID,

Date

From Tab2;

Aggr:

Load

Date,

DocType,

Count(DocID)

Resident Table1, Table2

Group By Date, DocType;

MayilVahanan — Tue, 28 May 2013 23:15:26 GMT

No..

But you can join two tables and then use aggr function. Like this

Table1:

Load

DocID,

DocType

From Tab1;

Left Join(Table1)

Load

DocID,

AltID,

Date

From Tab2;

Load

Date,

DocType,

Count(DocID)

Resident Table1

Group By Date, DocType;

Hope it helps