topic Re: Problem with Avg function in QlikView

Problem with Avg function

Tue, 02 Sep 2014 16:02:41 GMT

Hello Everybody,

I have a problem with my following expression :

I'm trying to make a custom multiple list with the following expression :

if(ESMS.CODE_CATEGORIE=200,10 * ($(v_pct_plafond)/100), $(v_capacite_au_01/01/N) * avg (COUT_MOYEN_NATIONAL.COUT_MOYEN) * ($(v_pct_plafond)/100)).

It doesn't work beacuse of the AVG function.

When i replace the AVG expression with a constant, it works perfectly, i can choose any value as I want to.

Can you please explain me why? Is there any solution to make it work with the avg function?

We previously faced the same problem with sum() function and it seems that "aggr()" was the solution.

But this time, it's a bit more complicated

Re: Problem with Avg function

JonnyPoole — Tue, 02 Sep 2014 16:07:48 GMT

you may need to wrap the existing expression in an aggr()

Aggr( <existing expression > , <Dimension> )

If you are using it in a chart with multiple dimensions, list all dimensions.

if you get stuck see if you can attach a QVW sample

Re: Problem with Avg function

Tue, 02 Sep 2014 16:15:11 GMT

Ok, I will try different uses of the Aggr() function, thank you.

Re: Problem with Avg function

Wed, 03 Sep 2014 15:59:42 GMT

it is indeed the right solution, thanks a lot .