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
Did you mean:
Highlighted
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

 Manifest Description Length Width Height Product Dims Qty Total Volume Per Product AA1000 Product 1 0,581 0,544 1,488 0,4703 40 18,812 AA1000 Product 2 0,581 0,544 1,488 0,4703 18 8,465 AA1000 Product 3 0,581 0,544 1,488 0,4703 10 4,703 AA1000 Product 4 0,722 0,816 0,928 0,5467 73 39,912 AA1000 Product 5 0,722 0,812 0,928 0,5441 22 11,969 AA1000 Product 6 0,661 0,644 1,653 0,7037 30 21,110 AA1000 Product 7 0,661 0,544 1,653 0,5944 15 8,916 AA1000 Product 8 0,661 0,544 1,653 0,5944 14 8,321 122,208 Manifest # Total Qty Total Volume AA1000 222 122,208
Labels (1)
• calculation

3 Replies
Highlighted
Master

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

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

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") 😉