Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have an expression ($Bonus 1) this way:
=num((sum((((PRECOMAQ_PRECOBASE) - (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL)) * PRECOMAQ_BONUS1_PERCENT)))
* Count({$<STATUS_NEGOCIACAO={'FATURADO'}>}CNC_ID)
)
The correct totals is 31.113,51 (sum values in collumn $ Bonus 1)
Qlikview is multiplying the "correct total" (31.113,51) with sum Qtde Faturados (12)
Who to correct this?
If this is a straight table, try using Sum of Rows for your total mode on the expression tab. For pivot table, you can try this:
Num(
Sum(Aggr(
(Sum((((PRECOMAQ_PRECOBASE) - (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL)) * PRECOMAQ_BONUS1_PERCENT))) * Count({$<STATUS_NEGOCIACAO={'FATURADO'}>}CNC_ID), YourDimensionsHereSeparatedByCommas)))
I didnot check your Expression, but there is another way
goto tab Expression, on right Hand site there is Definition for total
Change to sum of rows and it should give you your correct sum
(you should check your Expression in first place)
in the expression section on the middle right hand it, there is an expression totals, change that to sum of rows, instead of expression total
Hi
It could be that you need to use dimensionality function so you can do a different calculation at total level to detail level. Can you share a small app or some more details please?
Hi, here is my project.
Please help me
This?
=Sum(Aggr(
(Sum(
(((PRECOMAQ_PRECOBASE)
- (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL))
* PRECOMAQ_BONUS1_PERCENT)
))
* Count({$<STATUS_NEGOCIACAO={'FATURADO'}>}CNC_ID), PRECOMAQ_MODELO, MES_VENDA))
Assuming PRECOMAQ_MODELO is a Unique Identifier for this chart.