7 Replies Latest reply: Jun 6, 2016 2:46 PM by Marcos Vinicius Coltro

Problem with total in dinamic table

Hi, I have an expression (\$Bonus 1)  this way:

=num((sum((((PRECOMAQ_PRECOBASE) - (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL)) * PRECOMAQ_BONUS1_PERCENT)))

)

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?

• Re: Problem with total in dinamic table

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

• Re: Problem with total in dinamic table

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)

• Re: Problem with total in dinamic table

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

• Re: Problem with total in dinamic table

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?

• Re: Problem with total in dinamic table

Hi, here is my project.

• Re: Problem with total in dinamic table

This?

=Sum(Aggr(

(Sum(

(((PRECOMAQ_PRECOBASE)

- (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL))

* PRECOMAQ_BONUS1_PERCENT)

))

Assuming PRECOMAQ_MODELO is a Unique Identifier for this chart.

• Re: Problem with total in dinamic table

Perfect Sunny T!!!

Great!!

Thanks a lot