topic Re: PivotGrid - Expression - Aggr with less dimension in QlikView

PivotGrid - Expression - Aggr with less dimension

Mon, 09 May 2016 21:27:04 GMT

Hi! I'm using a pivot grid

I need an expression with a calculated value using every dimension in pivot grid except one.

I can't show this value in every record of the pivot grid.

I attach an example:

Thanks

swuehl — Mon, 09 May 2016 22:19:43 GMT

I think you are experience a common Aggr() pit fall, a dimensional grain mismatch.

Try

=sum( Aggr(NODISTINCT ($(tMontoTraza_Pura)),PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag))

or maybe

=sum(TOTAL<PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag>

Aggr( ($(tMontoTraza_Pura)),PTOEspecie,MANIDestino,PTOProduccionTipo, PTOCalidad,PTORango_Ag))

Tue, 10 May 2016 14:04:01 GMT

Yes!! With TOTAL it works. Thanks for the solution and the blog link!