Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, guys!
I'm facing an error to totalize a measure on Qlik Sense.
The measure is the one below:
//VALOR RECEBIDO
=
IF(([Ano Documento Vendas - (VBAK-ERDAT)]<=[Ano Documento Faturamento - (VBRK-FKDAT)]
OR [Mês Documento Vendas - (VBAK-ERDAT)]<=[Mês Documento Faturamento - (VBRK-FKDAT)]),
SUM({<[OV Tipo - (VBAK-AUART)]={'Ordem de Venda Unifort'},
[Recusa OV - (VBAP-ABGRU)]-={'87', '88', '89'},
[Tipo de condição - (KONV11-KSCHL)]={'ZEVI'}>}
[Montante da Condição - (KONV11-KWERT)])
,'0')
Basicaly I want grab the value of docs who has been billed and show the original value of the reception of the doc.
For example:
I have a doc with the value of R$1.000,00 and we billed only R$500,00, so I want to show the value of R$1.000,00
if this doc hasnt been billed, It has to show R$0,00.
Doing that my x-table show me the correct values in the cells, but I cant receive a total for that measure.
Is that something wrong there?
Thank you guys for the help!
try to replace this by using [Recusa OV - (VBAP-ABGRU)]=sum{*} - [Recusa OV - (VBAP-ABGRU)]={'87', '88', '89'}
@Channa wrote:try to replace this by using [Recusa OV - (VBAP-ABGRU)]=sum{*} - [Recusa OV - (VBAP-ABGRU)]={'87', '88', '89'}
Channa, thank you for you reply!
I tried your line and it didn't worked.
Here's the srceenshot. Am I doing it right?
Guys,
I was doing some research and found out that the function AGGR() can solve my problem, but with AGGR() on it I still can't totalize!
Here's my mod formula
//VALOR RECEBIDO
(
IF((
[Data de criação do Documento de Vendas - (VBAK-ERDAT)] <= [Data doc.faturamento p/índice de docs.faturamto.e impressão - (VBRK-FKDAT)]),
SUM(AGGR(SUM({<[OV Tipo - (VBAK-AUART)]={'Ordem de Venda Unifort'},
[Recusa OV - (VBAP-ABGRU)]-={'87', '88', '89'},
[Tipo de condição - (KONV11-KSCHL)]={'ZEVI'}>}
[Montante da Condição - (KONV11-KWERT)]), [Categoria Material - (AUSP)], [Ordem de Vendas - (VBAP-VBELN)],[Nº do material - (VBAP-MATNR)]))
,'0')
)
Someone please can help me?