topic Help on aggr expression in QlikView

Help on aggr expression

Tue, 10 Jan 2012 14:59:53 GMT

Hi,

I need to find the minimum sales aggregated by Weeks. This needs to be calculated irrespective of the selected week. But the selections on other dimensions can affect the min sales value.

How can we acheive it? Refer the attachment

Help on aggr expression

Tue, 10 Jan 2012 15:03:37 GMT

Try this:

=min({<Week=>}aggr(sum({<Flag={1},Week=>} Sales),Week))

Re: Help on aggr expression

swuehl — Tue, 10 Jan 2012 15:07:28 GMT

Try maybe

=min( {<Flag={1},Week=>} aggr(sum({<Flag={1},Week=>} Sales),Week))

edit: Marc was somewhat faster. Same idea, just need to clarify how to handle the Flag field.

Re: Help on aggr expression

Tue, 10 Jan 2012 15:11:50 GMT

It is working. Thank you...