Pivot table with multiple dimensions

gshockxcc — Wed, 26 Jul 2017 23:39:21 GMT

Greetings all,

I am trying to create a Pivot table as shown below, but with the Received Material, Promised Material, and Total Material as stacked dimensions under the Project dimension, as shown below.

I am fairly certain that I was able to do this at one point. I no longer have access to Qlikview Enterprise, so I can't reference old files.

I am loading from two separate spreadsheets. Here's my load script:

Data2:

LOAD

Job,

Part,

Desc As Description,

Asm,

Mtl As Material,

[Project ID],

PO,

Line ,

Money#([Unit Price]) As UnitPrice,

Num#([Received Qty]) As [Promised Material],

Date([Promise Date]) As Promise_Date,

Date([Promise Date]) As Date,

Num#([Rel Qty]) As RelQty,

OpenOrder,

Approve

FROM

(txt, utf8, embedded labels, delimiter is ',');

Concatenate

LOAD

Job,

[Job Complete],

Asm,

Mtl As Material,

Part,

Desc As Description,

[Project ID],

PO,

Line,

Money#([Unit Price]) As UnitPrice,

Num#([Received Qty]) As [Received Material],

Date([Receipt Date]) As Promise_Date,

Date([Receipt Date]) As Date,

Num#([Our Quantity - Received]) As OurReceivedQty

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',');

Here's what I'm ending up with.

Any help would be greatly appreciated.

Thank you.

Re: Pivot table with multiple dimensions

lfetensini — Wed, 26 Jul 2017 23:56:32 GMT

Please, do you can upload your files to see entire development? CVS and QVW?

Re: Pivot table with multiple dimensions

gshockxcc — Fri, 28 Jul 2017 13:46:25 GMT

Please see attached. Thank you in advance.

Re: Pivot table with multiple dimensions

Nagaraju_KCS — Fri, 28 Jul 2017 14:07:07 GMT

Try This,

In your expression...

=Aggr(Sum(ReceivedQty), Mtl, OurQuantityReceived, MonthYear)

Re: Pivot table with multiple dimensions

gshockxcc — Sun, 13 Aug 2017 03:43:03 GMT

Cheers, Raju. That worked.

topic Re: Pivot table with multiple dimensions in QlikView

Pivot table with multiple dimensions

Re: Pivot table with multiple dimensions

Re: Pivot table with multiple dimensions

Re: Pivot table with multiple dimensions

Re: Pivot table with multiple dimensions