topic Aggregating based on a particular dimension in a straight table in QlikView

Aggregating based on a particular dimension in a straight table

Mon, 07 Jul 2014 18:30:40 GMT

Hi All,

I have a straight table with dimensions like state, city, distributor and retailers are their and then some expressions are there. Now my requirement is to show one of the expressions based on distributors i.e. the aggregation should be done on the distrbutors and not on the retailers. For every retailer it should show the same value i.e. the total for that distributor to which the retailer belongs to.

Re: Aggregating based on a particular dimension in a straight table

maxgro — Mon, 07 Jul 2014 18:59:56 GMT

to evaluate the expression at the distributor level

sum( total <distributor> expression)

sum( total <field1,field2> exp)

sum(total exp)

Re: Aggregating based on a particular dimension in a straight table

Mon, 07 Jul 2014 19:07:53 GMT

Thanks.