topic Aggr applied to all data in QlikView

Aggr applied to all data

paulo_costa_ifp — Mon, 26 Jan 2026 18:19:17 GMT

I have a set of monthy agregated data like lines below:

Monthname count(TransID)

jan/17 1000

feb/17 500

mar/17 700

apr/17 1500

may/17 350

jun/17 2000

The function below returns the "best" Monthname value:

max(aggr(count({<[trans_type]-={'OXY'}>}[TransID]),[Monthname])) = 2000

If we filter jan/17 - mar/17, the function will return 1000. I would like to have a similar function, in order to get the best Monthname value from all data. In this way, if we filter jan/17 - mar/17, the function will return 2000.

Re: Aggr applied to all data

vishsaggi — Sun, 25 Jun 2017 21:57:32 GMT

May be this:

= max(TOTAL {<Monthname>} Aggr(count({1<[trans_type]-={'OXY'}>}[TransID]),[Monthname]))

Re: Aggr applied to all data

antoniotiman — Sun, 25 Jun 2017 22:00:04 GMT

Hi Paulo,

try this

max({<Monthname=>} aggr(count({<[trans_type]-={'OXY'},Monthname=>}[TransID]),[Monthname]))

Regards.

Antonio

Re: Aggr applied to all data

paulo_costa_ifp — Sun, 25 Jun 2017 22:52:55 GMT

It´snot running fine.