topic Re: Problem with total in dinamic table in QlikView

Problem with total in dinamic table

Mon, 06 Jun 2016 15:21:16 GMT

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?

Re: Problem with total in dinamic table

sunny_talwar — Mon, 06 Jun 2016 15:28:58 GMT

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

Anonymous — Mon, 06 Jun 2016 15:29:37 GMT

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

ramoncova06 — Mon, 06 Jun 2016 15:30:31 GMT

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

Anonymous — Mon, 06 Jun 2016 15:31:19 GMT

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

Mon, 06 Jun 2016 16:50:41 GMT

Hi, here is my project.

Please help me

Re: Problem with total in dinamic table

sunny_talwar — Mon, 06 Jun 2016 18:30:12 GMT

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.

Re: Problem with total in dinamic table

Mon, 06 Jun 2016 18:46:02 GMT

Perfect stalwar1!!!

Great!!

Thanks a lot