Grand total with Absolute value

bharani8 — Sat, 16 Nov 2024 20:11:21 GMT

Hi Team - I have issue in Populating "Shipment %" because Values which are populated in "Shipment Delta" are Absolute values. What output i need from the below screen shot is.. For Grandtotal (Bolded in last row), for "Shipment %" it should calculate 3870/1164425 which is 0.33%.. "Shipment Delta"(OARS Shipment Qty - ODW Shipment Qty) are Absolute values. 3870 is Sum of all the Rows (Not Expression Total). Now how do we get this to 0.33% ?

@sunny_talwar Hope u have different approach to get this done.. Counting on u!

Expressions used for below 4 columns are:

OARS Ship Qty : Sum(GROSS_SHIP_QT) Grand Total: Expression Total (Total Mode)

ODW Ship Qty : Sum([L4 Gross Shipment MS Quantity]) Grand Total: Expression Total (Total Mode)

Shipment Delta : fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity])) Grand Total: Sum of Rows(Total Mode)

Shipment % : fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity]))/sum(GROSS_SHIP_QT) Grand Total: Expression Total (Total Mode)

Regards

Bharani

Re: Grand total with Absolute value

sunny_talwar — Wed, 28 Aug 2019 11:04:35 GMT

Not sure what the chart dimension/s are, but assuming they are A, B, & C.... try this

Sum(Aggr( fabs(Sum(GROSS_SHIP_QT) - Sum([L4 Gross Shipment MS Quantity])) , A, B, C)) / Sum(Aggr( Sum(GROSS_SHIP_QT) , A, B, C))

Re: Grand total with Absolute value

bharani8 — Wed, 28 Aug 2019 13:57:43 GMT

Worked Perfectly!!! U r a Star!! Tks for helping on this!! 🙂

topic Re: Grand total with Absolute value in QlikView

Grand total with Absolute value

Re: Grand total with Absolute value

Re: Grand total with Absolute value