Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Problems with AGGR

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

1 Solution

Accepted Solutions
Highlighted

Problems with AGGR

Hi,

     I think you this kind of expression.

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

Celambarasan

View solution in original post

3 Replies
Highlighted

Problems with AGGR

Hi,

     I think you this kind of expression.

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

Celambarasan

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

Problems with AGGR

Hi,

Try the below expressoin

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

Regards,

Jagan.

Highlighted
New Contributor II

Problems with AGGR

Celambarasan,I think you read minds

Thanks,

both of you