Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Double values in Aggr and Total Line.

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))

 

2020-07-22_16-21-28.jpg

Neves
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

DOCUMENTOFISCALORIGINAL,DATAMOVIMENTO1,CODIGOPESSOA,CODIGOVENDEDOR,PESOLIQUIDOPRODUTO

 

2020-07-22_21-25-25.jpg

Neves

View solution in original post

2 Replies
Highlighted
MVP
MVP

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

Highlighted
Specialist
Specialist

DOCUMENTOFISCALORIGINAL,DATAMOVIMENTO1,CODIGOPESSOA,CODIGOVENDEDOR,PESOLIQUIDOPRODUTO

 

2020-07-22_21-25-25.jpg

Neves

View solution in original post