topic Re: Help with sum min / max in QlikView

Help with sum min / max

Fri, 11 Jan 2013 08:40:50 GMT

Hi,

i alrady tried some suggestions in this forum but can not solve my Problem.

Now I need the sum of the min of each name

min A = 1

min B = 2

sum = 3

I have tried something like this: min(aggr(min([Number]),)) but it doesnt work...

Thanks!

nirav_bhimani — Fri, 11 Jan 2013 08:57:11 GMT

Hi,

Try this,

=Sum(aggr(Min(Number),Name ))

Regards,

Nirav Bhimani

Fri, 11 Jan 2013 09:16:26 GMT

thanks - but it seems that it does not work this way..

Fri, 11 Jan 2013 09:24:17 GMT

Thanks for your Help! I think i've got it:

Sum(Total<Number> aggr(Min(Number),Name))