topic Re: Aggr in QlikView

Aggr

Anonymous — Mon, 15 Sep 2014 16:39:10 GMT

Hello,

I want to sum([Units YTD]) for the max([Period_Number]) and aggr by Buyer Name. How exactly can I do this?

Thanks,

Isabel

tresB — Mon, 15 Sep 2014 17:01:17 GMT

May be like:

Straight table:

Dimension: [Buyer Name]

Expression: =Sum({<[Period Number]={"$(=Max([Period Number]))"}>} [Units YTD])

Anonymous — Mon, 15 Sep 2014 17:04:00 GMT

Hello,

Thank you, that works as a straight table however I should have mentioned that I am trying to do it as a text object.

Thanks,

Isabel

tresB — Mon, 15 Sep 2014 17:10:22 GMT

Are you expecting a single value as output? If so, then what do you really mean by '... and aggr by Buyer Name' ? Could you explain a bit more?

simondachstr — Mon, 15 Sep 2014 17:14:01 GMT

Based on tresesco's post try the following:

=aggr([Buyer Name], sum({<[Period_Number])={"$(=Max([Period Number]))"}>} [Units YTD]))

Note, however, if you have multiple Buyer Names you might need to aggregate your result.

Anonymous — Mon, 15 Sep 2014 17:38:56 GMT

Hello,

Yes, I do have multiple buyer names and would like the result based on the Buyer Name selected in a list box.

Thanks,

Isabel