topic Using AGGR & AVG Function in Set Analysis in QlikView

Using AGGR & AVG Function in Set Analysis

Sun, 23 Mar 2014 00:27:14 GMT

Hi :

Could some one help me,

if I need to use the following expression by substituting the SUM function with AVG

AGGR(NODISTICT(SUM({<PERIOD={$(=MAX(PERIOD))},YEAR={$(=MAX(YEAR))}>} Amount))), Category, Class)

when I tried using with AVG function the resulting number is erroneous and does not give the average.

Appreciate in advance any help that can be extended

Kumar

its_anandrjs — Sun, 23 Mar 2014 06:33:44 GMT

Hi,

You could write a script like

=AGGR(NODISTINCT SUM({<PERIOD={$(=MAX(PERIOD))},YEAR={$(=MAX(YEAR))}>} Amount), Category, Class)

Hope this helps

Thanks & Regards

its_anandrjs — Sun, 23 Mar 2014 06:37:43 GMT

Hi,

Try for avg script like

=Avg( AGGR( NODISTINCT SUM({<PERIOD={$(=MAX(PERIOD))}, YEAR={$(=MAX(YEAR))} >}Amount), Category, Class))

Hope this helps

Thanks & Regards

Sun, 23 Mar 2014 18:55:46 GMT

Hi, thanks Anand , but the result gives error in calculation