Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

* 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?

imagem_qlikview.jpg

7 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

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)

ramoncova06
Specialist III
Specialist III

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

Anonymous
Not applicable
Author

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?

Not applicable
Author

Hi, here is my project.

Please help me

sunny_talwar

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.

Capture.PNG

Not applicable
Author

Perfect stalwar1!!!

Great!!

Thanks a lot