Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Not respecting the selection of a field in Aggr

Hi guys,

I have a query about not respecting the selection of a field, which although I add in the set analysis the condition not working, the field is the [Material EM], but when I remove field from the aggr already works correctly.

8.PNG

=

sum({$<[Desc Material EM]=,[Material EM]=>}MSEG.Importe_SOLES)

*

avg(

{$<[Desc Material EM]=,[Material EM]=>}

AGGR(

fabs(sum({$<[Tipo Movimiento]={'Salida'},[Almacén EM] ={'*'}-{''},[Desc Material EM]=,[Material EM]=>}MSEG.Cantidad_MENGE))

/

Aggr( rangesum(Above( sum({$<[Año EM]=,[Mes EM]=,[Desc Material EM]=,[Material EM]=>}MSEG.Cantidad_MENGE), 1, RowNo())) ,([Periodo EM],(NUMERIC,ASCENDING)) )

,[Año EM],[Mes EM],[Material EM]))

Thanks so much.

0 Replies