topic Re: Double values in Aggr and Total Line. in QlikView

Double values in Aggr and Total Line.

Ribeiro — Wed, 22 Jul 2020 19:30:47 GMT

I need to correct the set analysis below because it is folded.

I need to get the amount with the correct name:

Any tips.

IF(Sum(Aggr(Only({$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL), CODIGOPRODUTO,DOCUMENTOFISCALORIGINAL,CODIGOPESSOA,DATAMOVIMENTO1)),
Sum(TOTAL <DOCUMENTOFISCALORIGINAL,CODIGOPESSOA,DATAMOVIMENTO1>{$<[EFETIVADA]={'1'},[CANCELADA]={'0'},[EVENDA]={'1'},[TIPOSAIDAENTRADA]={'S'}>}VALORTOTAL))

Re: Double values in Aggr and Total Line.

Kushal_Chawda — Wed, 22 Jul 2020 22:53:36 GMT

Can't open QVW. Can you tell me what are the dimensions and measures and what is expected?

Re: Double values in Aggr and Total Line.

Ribeiro — Thu, 23 Jul 2020 00:26:41 GMT

DOCUMENTOFISCALORIGINAL,DATAMOVIMENTO1,CODIGOPESSOA,CODIGOVENDEDOR,PESOLIQUIDOPRODUTO