topic Re: My Aggr or set analysis problem in QlikView

My Aggr or set analysis problem

josephinetedesc — Sun, 02 Oct 2016 23:09:34 GMT

Hi All

I have been trying to do get a total total cost:

The formula for getting the no of Records is

count(distinct{<ClassTypeName = { 'Sim'}>}([RecNo()]))

How do I get the total COST which is costWeight * No. Recs

I have read about aggr function but I do not know where to apply the function.

Thank you for any help you can give.

jonathandienst — Mon, 03 Oct 2016 05:12:10 GMT

Like this:

=Sum(Aggr(costWeight * Count({<ClassTypeName = { 'Sim'}>} DISTINCT RecNo()]), ClassType, ClassTypeDesc))

If this is in a chart with more dimensions, then you need to include all the chart dimensions in the list of dimensions for the Aggr()

josephinetedesc — Mon, 03 Oct 2016 06:58:41 GMT

Thank you Jonathan - worked beautifully,

Now all I have to do is study it and figure out why

Thanks again