Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Creating a Product Delivery Summary

Hi All

I am stuck with the below calculation. I have data coming at a single product level (Per Parcel). Each Parcel has specific dimensions. I need to be able to consolidate the dimensions into a single line total. Below is a table I created to try explain the layout and end result. If I work it out in Excel, I get the correct final total.

The end result must be a single consolidate row in Red Below. 

It is probably very simple solution, but I have tried everything to get to that total and cant. 

I would appreciate any assistance

ManifestDescriptionLengthWidthHeightProduct DimsQtyTotal Volume Per Product
AA1000Product 10,5810,5441,4880,47034018,812
AA1000Product 20,5810,5441,4880,4703188,465
AA1000Product 30,5810,5441,4880,4703104,703
AA1000Product 40,7220,8160,9280,54677339,912
AA1000Product 50,7220,8120,9280,54412211,969
AA1000Product 60,6610,6441,6530,70373021,110
AA1000Product 70,6610,5441,6530,5944158,916
AA1000Product 80,6610,5441,6530,5944148,321
       122,208
        
 Manifest #Total QtyTotal Volume    
 AA1000222122,208    
Labels (1)
3 Replies
Highlighted
Master
Master

@Tobievr 

how to obtain 222 for total qty ?

Isn't that what you're looking for :

dimension :Manifest

Measure 1:sum(Total volume)

Mzasure 2: sum(qty)

?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Contributor
Contributor

Hi. 

I dont have last 2 columns data. I have a per product dimension and a count of parcels for each product and I am looking for the formula that will Consolidate the 3 dimensions, multiply it by a parcel count to get a volume per product and then sum all of it to get the end result.

I know my explanation is not very good. 

Thanks

Highlighted
Master
Master

If I understood correctly :

you need a three-column table:

  • Manifest
  • sum(Total volume)
  • sum(qty)

and how u get 222 for qty ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉