Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gshockxcc
Creator
Creator

Pivot table with multiple dimensions

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. 

Capture.PNG

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.

1 Solution

Accepted Solutions
qv_testing
Specialist II
Specialist II

Try This,

In your expression...

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

View solution in original post

4 Replies
lfetensini
Partner - Creator II
Partner - Creator II

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

Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.
gshockxcc
Creator
Creator
Author

Please see attached.  Thank you in advance.

qv_testing
Specialist II
Specialist II

Try This,

In your expression...

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

gshockxcc
Creator
Creator
Author

Cheers, Raju.  That worked.