Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try This,
In your expression...
=Aggr(Sum(ReceivedQty), Mtl, OurQuantityReceived, MonthYear)
Please, do you can upload your files to see entire development? CVS and QVW?
Please see attached. Thank you in advance.
Try This,
In your expression...
=Aggr(Sum(ReceivedQty), Mtl, OurQuantityReceived, MonthYear)
Cheers, Raju. That worked.