topic Re: Problem with aggregation formula (table) in QlikView

Problem with aggregation formula (table)

Wed, 17 Sep 2014 10:49:16 GMT

Hello

I would like to ask how can I “repeat” the same number , which is an aggregation of total skus per stores, to the entire table.

On my QV I have the following:

Brand =avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

A 226

B -

C -

And what I really want is this:

Brand =avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

A 226

B 226

C 226

Thank you very much beforehand.

tresB — Wed, 17 Sep 2014 10:53:16 GMT

NODISTINCT keyword.

=avg(aggr( NODISTINCT count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

PrashantSangle — Wed, 17 Sep 2014 11:03:07 GMT

Hi,

Try with putting Brand in AGGR()

avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store,Brand))

Regards

Wed, 17 Sep 2014 11:07:34 GMT

try this

=avg(aggr(nodistinct count({<Subsegment,Manufacturer,Brand>} EanCode),Store))

Thu, 18 Sep 2014 11:40:06 GMT

Thank you very much, it did work perfectly!