Getting a Total based on Multiple Fields

Wed, 25 Nov 2020 16:16:04 GMT

My current data set is this table here:

I want to pretty much condense the data down to something similar to this:

I want to sum the distinct [Total Value], based on the Plant and DESIGNATION.

For example:

Plant 6000, DESIGNATION TRAFFIC has two [Total Value]'s of 83.73. Which would equal a sum of 83.73.

Plant 6000, DESIGNATION PRODUCTION has three [Total Value]'s of 83.73. Which would equal a sum of 83.73.

Plant 6000, DESIGNATION HUBS has three [Total Value]'s of 83.73. Which would equal a sum of 83.73.

Now if Plant 6000, DESIGNATION TRAFFIC were to have multiple [Total Value]'s of let's say for example 83.73 and 116.27; I would want the sum to be 200. This is because the two distinct values of 83.73 and 116.27 from Plant 6000, DESIGNATION TRAFFIC, sum up to be 200.

Next, I want the sum of those three summations, so I could conclude that Plant 6000 has a conclusive total value of 251.19.

What expression would I have to use to accomplish this? I have been trying out different set analysis statements to accomplish this, but to no avail.

Thank you!

Re: Getting a Total based on Multiple Fields

ziadm — Thu, 13 Jul 2017 18:07:53 GMT

in the front end

straight or pivot table

Dimension

PLANT

DESIGNATION

expression

Max(Value)

Re: Getting a Total based on Multiple Fields

sunny_talwar — Thu, 13 Jul 2017 18:09:31 GMT

May be like this

Sum(Aggr(Sum(DISTINCT [Total Value]), Plant, DESIGNATION))

Re: Getting a Total based on Multiple Fields

Thu, 13 Jul 2017 19:08:10 GMT

Hot diggity dang. It worked like a charm. Thank you!!

topic Getting a Total based on Multiple Fields in QlikView

Getting a Total based on Multiple Fields

Re: Getting a Total based on Multiple Fields

Re: Getting a Total based on Multiple Fields

Re: Getting a Total based on Multiple Fields