topic Re: Making One Table from Two Tables? in QlikView

Making One Table from Two Tables?

bnelson111 — Fri, 10 Jul 2015 15:00:16 GMT

I have a task to make one table box from two tables, i have sums etc all done just now struggling to embed into one, i could do something in charts but just want this to stand alone in the presentation as a table box or a table of its own in the load statement.

current output looks like below.

I want the 90000 budget to sit on same line as aggr.total(£244,620.00)

Script is below.

[data]:

LOAD date,

month(date)as monthcompleted,

sales

FROM

(ooxml, embedded labels, table is Sheet1);

[Aggr.Table]:

LOAD

month(date) AS [date.Name],

num(Sum(sales),'£#,##0.00') AS [Aggr.Total Data]

RESIDENT [data]

WHERE

// (Key = 0) AND

(date >= AddMonths(Today(), -12))

GROUP BY month(date);

LOAD * INLINE [

Budget, date.Name

90000, Feb

];

Thanks in advance.

Re: Making One Table from Two Tables?

sunny_talwar — Fri, 10 Jul 2015 15:02:46 GMT

Edit your second Inline table to be this:

LOAD Budget,

Month(Date#(date.Name, 'MMM')) as date.Name

INLINE [

Budget, date.Name

90000, Feb

];

HTH

Best,

Sunny

Re: Making One Table from Two Tables?

sunny_talwar — Fri, 10 Jul 2015 15:04:32 GMT

Overall this:

[data]:

LOAD date,

month(date)as monthcompleted,

sales

FROM

(ooxml, embedded labels, table is Sheet1);

[Aggr.Table]:

LOAD Month(date) as [date.Name],

Num(Sum(sales),'£#,##0.00') as [Aggr.Total Data]

RESIDENT [data]

WHERE

// (Key = 0) AND

(date >= AddMonths(Today(), -12))

GROUP BY month(date);

LOAD Budget,

Month(Date#(date.Name, 'MMM')) as date.Name

INLINE [

Budget, date.Name

90000, Feb

];

Re: Making One Table from Two Tables?

bnelson111 — Fri, 10 Jul 2015 21:06:56 GMT

Thanks i see now. cheers