Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia,
Tenho uma tabela e um KPI somando valores. A soma está resultando em valor incorreto.
QLIK
Excel: (valor correto)
O que pode estar ocorrendo?
The Qlik engine does not calculate the sum of rows. It calculates the total sum, independent of "Segmento".
So, if a dollar belongs to more than one segment, it will NOT be counted twice in the total. In your case, you probably have approximately 200,000 $ that belong to more than one segment.
See https://community.qlik.com/t5/Design/Totals-in-Charts/ba-p/1464797
poderia compartilhar a formula do seu KPI por favor
The Qlik engine does not calculate the sum of rows. It calculates the total sum, independent of "Segmento".
So, if a dollar belongs to more than one segment, it will NOT be counted twice in the total. In your case, you probably have approximately 200,000 $ that belong to more than one segment.
See https://community.qlik.com/t5/Design/Totals-in-Charts/ba-p/1464797
sum([vl-merc-liq]+[vl-icmsub-it]+[vl-ipi-it])
+
sum([vl-frete]+[vl-seguro]+[vl-embalagem])
+
sum(icmsst)