topic Problems with AGGR in QlikView

Problems with AGGR

Anonymous — Thu, 16 Feb 2012 11:39:16 GMT

Hi everybody.

I hope you can help.

this is my table:

IDDEVICE DATETIME PAC IDPARK

1 2012-02-14 5 1

1 ..... 7 1

1 ...... 1 1

2 ..... 2 1

2 ..... 9 1

3 ..... 11 1

ecc.

In a graph i have chose IDDEVICE as Dimension.

In wrote this expression : Avg( Aggr((if(PAC>0,PAC)),IDPARK)) because for each IDDEVICE i want to calculate the Avg of every PAC(also from different IDDEVICE) but doesn't work.

My complete expression is :

Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])

Avg( Aggr((if(PAC>0,PAC)),IDPARK))

Thanks

Problems with AGGR

CELAMBARASAN — Thu, 16 Feb 2012 11:46:21 GMT

Hi,

I think you this kind of expression.

=Avg( {<[PAC]= {"=[PAC]>0"}>} [PAC])/Avg(TOTAL {<[PAC]= {"=[PAC]>0"}>} [PAC])

Celambarasan

Problems with AGGR

jagan — Thu, 16 Feb 2012 11:52:23 GMT

Hi,

Try the below expressoin

=Sum( {<[PAC]= {">0"}>} [PAC])/Count(TOTAL {<[PAC]= {">0"}>} [PAC])

Regards,

Jagan.

Problems with AGGR

Anonymous — Thu, 16 Feb 2012 14:14:07 GMT

Celambarasan,I think you read minds

Thanks,

both of you